SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002652s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000560s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001882s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.93' ) [ RunTime:0.000409s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001804s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.013116s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001664s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P6KE39CA' LIMIT 1 [ RunTime:0.022046s ]
UPDATE `stock_search` SET `count` = 17596 , `updatetime` = '2026-06-02 08:35:52' WHERE `partno` = 'P6KE39CA' [ RunTime:0.032956s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.007957s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.004002s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.016884s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002637s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'P6KE39CA%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.020589s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE 'P6KE39CA%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.037990s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('30235637','30228560','30228268','30216873','30216672','30202830','30201545','30201538','30198632','30194522','30194518','30185735','30174748','16691124','16687893','16671794','16668106','14827696','14814800','14807970') ORDER BY FIELD(s.id, 30235637,30228560,30228268,30216873,30216672,30202830,30201545,30201538,30198632,30194522,30194518,30185735,30174748,16691124,16687893,16671794,16668106,14827696,14814800,14807970) [ RunTime:0.079269s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30235637 LIMIT 4 [ RunTime:0.039675s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30235637 ORDER BY `minOrder` ASC [ RunTime:0.057552s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30235637 ORDER BY `unit` DESC [ RunTime:0.011017s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30235637 LIMIT 2 [ RunTime:0.022563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30235637 ORDER BY `minOrder` ASC [ RunTime:0.024868s ]
select * from pdf where partno='P6KE39CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.015162s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002637s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE39CA-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.007031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30228560 LIMIT 4 [ RunTime:0.016901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30228560 ORDER BY `minOrder` ASC [ RunTime:0.040146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30228560 ORDER BY `unit` DESC [ RunTime:0.009897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30228560 LIMIT 2 [ RunTime:0.004388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30228560 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
select * from pdf where partno='P6KE39CA-G' and brandshort='Comchip Technology' limit 1 [ RunTime:0.009362s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE39CA-G' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.014987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30228268 LIMIT 4 [ RunTime:0.012086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30228268 ORDER BY `minOrder` ASC [ RunTime:0.021514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30228268 ORDER BY `unit` DESC [ RunTime:0.009101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30228268 LIMIT 2 [ RunTime:0.004662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30228268 ORDER BY `minOrder` ASC [ RunTime:0.026881s ]
select * from pdf where partno='P6KE39CA-HF' and brandshort='Comchip Technology' limit 1 [ RunTime:0.005585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE39CA-HF' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.010268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30216873 LIMIT 4 [ RunTime:0.010860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30216873 ORDER BY `minOrder` ASC [ RunTime:0.004182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30216873 ORDER BY `unit` DESC [ RunTime:0.001658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30216873 LIMIT 2 [ RunTime:0.002267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30216873 ORDER BY `minOrder` ASC [ RunTime:0.004890s ]
select * from pdf where partno='P6KE39CAH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.002309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE39CAH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.009190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30216672 LIMIT 4 [ RunTime:0.008786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30216672 ORDER BY `minOrder` ASC [ RunTime:0.003373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30216672 ORDER BY `unit` DESC [ RunTime:0.003179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30216672 LIMIT 2 [ RunTime:0.016456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30216672 ORDER BY `minOrder` ASC [ RunTime:0.005008s ]
select * from pdf where partno='P6KE39CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.006051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE39CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.012789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30202830 LIMIT 4 [ RunTime:0.009860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30202830 ORDER BY `minOrder` ASC [ RunTime:0.008028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30202830 ORDER BY `unit` DESC [ RunTime:0.003222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30202830 LIMIT 2 [ RunTime:0.009171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30202830 ORDER BY `minOrder` ASC [ RunTime:0.006599s ]
select * from pdf where partno='P6KE39CA-BP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.012552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE39CA-BP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.026037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30201545 LIMIT 4 [ RunTime:0.051571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30201545 ORDER BY `minOrder` ASC [ RunTime:0.031780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30201545 ORDER BY `unit` DESC [ RunTime:0.010909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30201545 LIMIT 2 [ RunTime:0.015219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30201545 ORDER BY `minOrder` ASC [ RunTime:0.007940s ]
select * from pdf where partno='P6KE39CA-AP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.017610s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE39CA-AP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.005890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30201538 LIMIT 4 [ RunTime:0.001199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30201538 ORDER BY `minOrder` ASC [ RunTime:0.012545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30201538 ORDER BY `unit` DESC [ RunTime:0.012866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30201538 LIMIT 2 [ RunTime:0.000421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30201538 ORDER BY `minOrder` ASC [ RunTime:0.000266s ]
select * from pdf where partno='P6KE39CA_R2_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.001418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE39CA_R2_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.001775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30198632 LIMIT 4 [ RunTime:0.000663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30198632 ORDER BY `minOrder` ASC [ RunTime:0.010585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30198632 ORDER BY `unit` DESC [ RunTime:0.000451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30198632 LIMIT 2 [ RunTime:0.000359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30198632 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
select * from pdf where partno='P6KE39CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.002459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE39CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.008646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30194522 LIMIT 4 [ RunTime:0.001638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30194522 ORDER BY `minOrder` ASC [ RunTime:0.000755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30194522 ORDER BY `unit` DESC [ RunTime:0.007903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30194522 LIMIT 2 [ RunTime:0.002658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30194522 ORDER BY `minOrder` ASC [ RunTime:0.001247s ]
select * from pdf where partno='P6KE39CA-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.008170s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE39CA-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.024097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30194518 LIMIT 4 [ RunTime:0.009341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30194518 ORDER BY `minOrder` ASC [ RunTime:0.005781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30194518 ORDER BY `unit` DESC [ RunTime:0.000511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30194518 LIMIT 2 [ RunTime:0.007749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30194518 ORDER BY `minOrder` ASC [ RunTime:0.000277s ]
select * from pdf where partno='P6KE39CA-AT/B' and brandshort='YAGEO' limit 1 [ RunTime:0.001135s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE39CA-AT/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.007300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30185735 LIMIT 4 [ RunTime:0.000457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30185735 ORDER BY `minOrder` ASC [ RunTime:0.000762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30185735 ORDER BY `unit` DESC [ RunTime:0.000462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30185735 LIMIT 2 [ RunTime:0.002042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30185735 ORDER BY `minOrder` ASC [ RunTime:0.001527s ]
select * from pdf where partno='P6KE39CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.005767s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE39CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.003671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30174748 LIMIT 4 [ RunTime:0.005581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30174748 ORDER BY `minOrder` ASC [ RunTime:0.001491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30174748 ORDER BY `unit` DESC [ RunTime:0.000408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30174748 LIMIT 2 [ RunTime:0.005538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30174748 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
select * from pdf where partno='P6KE39CA' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.003061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6KE39CA' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.002807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691124 LIMIT 4 [ RunTime:0.001485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691124 ORDER BY `minOrder` ASC [ RunTime:0.000583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691124 ORDER BY `unit` DESC [ RunTime:0.006063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691124 LIMIT 2 [ RunTime:0.000532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691124 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687893 LIMIT 4 [ RunTime:0.000762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687893 ORDER BY `minOrder` ASC [ RunTime:0.011224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687893 ORDER BY `unit` DESC [ RunTime:0.003128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687893 LIMIT 2 [ RunTime:0.004886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687893 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671794 LIMIT 4 [ RunTime:0.002119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671794 ORDER BY `minOrder` ASC [ RunTime:0.002036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671794 ORDER BY `unit` DESC [ RunTime:0.002336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671794 LIMIT 2 [ RunTime:0.003320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671794 ORDER BY `minOrder` ASC [ RunTime:0.001737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668106 LIMIT 4 [ RunTime:0.008294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668106 ORDER BY `minOrder` ASC [ RunTime:0.001081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668106 ORDER BY `unit` DESC [ RunTime:0.002546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668106 LIMIT 2 [ RunTime:0.006437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668106 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827696 LIMIT 4 [ RunTime:0.002750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827696 ORDER BY `minOrder` ASC [ RunTime:0.002552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14827696 ORDER BY `unit` DESC [ RunTime:0.001778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14827696 LIMIT 2 [ RunTime:0.005686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827696 ORDER BY `minOrder` ASC [ RunTime:0.002707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814800 LIMIT 4 [ RunTime:0.001036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814800 ORDER BY `minOrder` ASC [ RunTime:0.003551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814800 ORDER BY `unit` DESC [ RunTime:0.000622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814800 LIMIT 2 [ RunTime:0.000611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814800 ORDER BY `minOrder` ASC [ RunTime:0.004845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807970 LIMIT 4 [ RunTime:0.005203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807970 ORDER BY `minOrder` ASC [ RunTime:0.004611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14807970 ORDER BY `unit` DESC [ RunTime:0.000617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14807970 LIMIT 2 [ RunTime:0.008310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807970 ORDER BY `minOrder` ASC [ RunTime:0.005157s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'P6KE39CA%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.000573s ]