SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001368s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=64306&search=1' [ RunTime:0.002414s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002153s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003957s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002614s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.008684s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003940s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.006340s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002502s ]
SELECT * FROM `stock_search` WHERE `partno` = '64306' LIMIT 1 [ RunTime:0.007061s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-23 01:24:44' WHERE `partno` = '64306' [ RunTime:0.031258s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003454s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '64306%' OR `brand` LIKE '64306%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029722s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12616179 LIMIT 5 [ RunTime:0.023715s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616179 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12616179 ORDER BY `unit` DESC [ RunTime:0.016666s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12616179 LIMIT 2 [ RunTime:0.005777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616179 ORDER BY `minOrder` ASC [ RunTime:0.002346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12615011 LIMIT 5 [ RunTime:0.010329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12615011 ORDER BY `minOrder` ASC [ RunTime:0.025657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12615011 ORDER BY `unit` DESC [ RunTime:0.006373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12615011 LIMIT 2 [ RunTime:0.016563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12615011 ORDER BY `minOrder` ASC [ RunTime:0.003524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612884 LIMIT 5 [ RunTime:0.046071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612884 ORDER BY `minOrder` ASC [ RunTime:0.003627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612884 ORDER BY `unit` DESC [ RunTime:0.030507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612884 LIMIT 2 [ RunTime:0.001192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612884 ORDER BY `minOrder` ASC [ RunTime:0.018962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612854 LIMIT 5 [ RunTime:0.020010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612854 ORDER BY `minOrder` ASC [ RunTime:0.056898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612854 ORDER BY `unit` DESC [ RunTime:0.064801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612854 LIMIT 2 [ RunTime:0.027107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612854 ORDER BY `minOrder` ASC [ RunTime:0.004088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613176 LIMIT 5 [ RunTime:0.021271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613176 ORDER BY `minOrder` ASC [ RunTime:0.016256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12613176 ORDER BY `unit` DESC [ RunTime:0.002351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12613176 LIMIT 2 [ RunTime:0.012130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613176 ORDER BY `minOrder` ASC [ RunTime:0.004029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6278 LIMIT 5 [ RunTime:0.008049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6278 ORDER BY `minOrder` ASC [ RunTime:0.003314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6278 ORDER BY `unit` DESC [ RunTime:0.005187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6278 LIMIT 2 [ RunTime:0.009515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6278 ORDER BY `minOrder` ASC [ RunTime:0.026520s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '643067-7' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.003379s ]
SELECT `id` FROM `stock` WHERE `id` <> 6278 AND `partno` = '643067-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.011457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6858 LIMIT 5 [ RunTime:0.043597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6858 ORDER BY `minOrder` ASC [ RunTime:0.011905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6858 ORDER BY `unit` DESC [ RunTime:0.013780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6858 LIMIT 2 [ RunTime:0.010012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6858 ORDER BY `minOrder` ASC [ RunTime:0.006573s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '643067-2' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.006619s ]
SELECT `id` FROM `stock` WHERE `id` <> 6858 AND `partno` = '643067-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.003458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612960 LIMIT 5 [ RunTime:0.005730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612960 ORDER BY `minOrder` ASC [ RunTime:0.000525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612960 ORDER BY `unit` DESC [ RunTime:0.012046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612960 LIMIT 2 [ RunTime:0.011578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612960 ORDER BY `minOrder` ASC [ RunTime:0.005647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10865917 LIMIT 5 [ RunTime:0.003236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10865917 ORDER BY `minOrder` ASC [ RunTime:0.002821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10865917 ORDER BY `unit` DESC [ RunTime:0.002359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10865917 LIMIT 2 [ RunTime:0.004461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10865917 ORDER BY `minOrder` ASC [ RunTime:0.005825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10862668 LIMIT 5 [ RunTime:0.002634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10862668 ORDER BY `minOrder` ASC [ RunTime:0.003218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10862668 ORDER BY `unit` DESC [ RunTime:0.008069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10862668 LIMIT 2 [ RunTime:0.019221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10862668 ORDER BY `minOrder` ASC [ RunTime:0.014721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10863697 LIMIT 5 [ RunTime:0.010216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10863697 ORDER BY `minOrder` ASC [ RunTime:0.007447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10863697 ORDER BY `unit` DESC [ RunTime:0.017101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10863697 LIMIT 2 [ RunTime:0.016765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10863697 ORDER BY `minOrder` ASC [ RunTime:0.004277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15216347 LIMIT 5 [ RunTime:0.013690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15216347 ORDER BY `minOrder` ASC [ RunTime:0.008666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15216347 ORDER BY `unit` DESC [ RunTime:0.001000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15216347 LIMIT 2 [ RunTime:0.003375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15216347 ORDER BY `minOrder` ASC [ RunTime:0.000550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14175471 LIMIT 5 [ RunTime:0.002448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14175471 ORDER BY `minOrder` ASC [ RunTime:0.003632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14175471 ORDER BY `unit` DESC [ RunTime:0.001809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14175471 LIMIT 2 [ RunTime:0.004363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14175471 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14175034 LIMIT 5 [ RunTime:0.003839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14175034 ORDER BY `minOrder` ASC [ RunTime:0.018008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14175034 ORDER BY `unit` DESC [ RunTime:0.016458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14175034 LIMIT 2 [ RunTime:0.017063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14175034 ORDER BY `minOrder` ASC [ RunTime:0.011289s ]
select * from pdf where partno='643068' and brandshort='Astro Tool Corp' limit 1 [ RunTime:0.008344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12615523 LIMIT 5 [ RunTime:0.002442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12615523 ORDER BY `minOrder` ASC [ RunTime:0.012254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12615523 ORDER BY `unit` DESC [ RunTime:0.013745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12615523 LIMIT 2 [ RunTime:0.001284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12615523 ORDER BY `minOrder` ASC [ RunTime:0.010989s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '64306%' OR `brand` LIKE '64306%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009091s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '64306%' OR `brand` LIKE '64306%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361768 LIMIT 5 [ RunTime:0.006077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361768 ORDER BY `minOrder` ASC [ RunTime:0.022567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361768 ORDER BY `unit` DESC [ RunTime:0.001833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361768 LIMIT 2 [ RunTime:0.000558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361768 ORDER BY `minOrder` ASC [ RunTime:0.005418s ]
select * from pdf where partno='643067-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001072s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '643067-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.016205s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361768 AND `partno` = '643067-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.007306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612884 [ RunTime:0.008035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361678 LIMIT 5 [ RunTime:0.001029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361678 ORDER BY `minOrder` ASC [ RunTime:0.026939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361678 ORDER BY `unit` DESC [ RunTime:0.013758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361678 LIMIT 2 [ RunTime:0.003654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361678 ORDER BY `minOrder` ASC [ RunTime:0.002851s ]
select * from pdf where partno='643067-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000939s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '643067-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007509s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361678 AND `partno` = '643067-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.008448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12615011 [ RunTime:0.001059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361789 LIMIT 5 [ RunTime:0.005343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361789 ORDER BY `minOrder` ASC [ RunTime:0.010655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361789 ORDER BY `unit` DESC [ RunTime:0.011284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361789 LIMIT 2 [ RunTime:0.017450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361789 ORDER BY `minOrder` ASC [ RunTime:0.002572s ]
select * from pdf where partno='643067-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.017404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '643067-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.011308s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361789 AND `partno` = '643067-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.031199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12616179 [ RunTime:0.020021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361800 LIMIT 5 [ RunTime:0.008602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361800 ORDER BY `minOrder` ASC [ RunTime:0.002307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361800 ORDER BY `unit` DESC [ RunTime:0.001956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361800 LIMIT 2 [ RunTime:0.006305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361800 ORDER BY `minOrder` ASC [ RunTime:0.012033s ]
select * from pdf where partno='643067-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.012335s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '643067-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.010313s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361800 AND `partno` = '643067-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612854 [ RunTime:0.011285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361802 LIMIT 5 [ RunTime:0.007531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361802 ORDER BY `minOrder` ASC [ RunTime:0.008599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361802 ORDER BY `unit` DESC [ RunTime:0.026269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361802 LIMIT 2 [ RunTime:0.004442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361802 ORDER BY `minOrder` ASC [ RunTime:0.004646s ]
select * from pdf where partno='643067-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.018234s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '643067-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.012916s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361802 AND `partno` = '643067-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.031595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12615523 [ RunTime:0.025274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361788 LIMIT 5 [ RunTime:0.016799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361788 ORDER BY `minOrder` ASC [ RunTime:0.037187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361788 ORDER BY `unit` DESC [ RunTime:0.023907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361788 LIMIT 2 [ RunTime:0.001829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361788 ORDER BY `minOrder` ASC [ RunTime:0.023807s ]
select * from pdf where partno='643067-8' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.039987s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '643067-8' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009343s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361788 AND `partno` = '643067-8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.017477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60362356 LIMIT 5 [ RunTime:0.020952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60362356 ORDER BY `minOrder` ASC [ RunTime:0.025175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60362356 ORDER BY `unit` DESC [ RunTime:0.014500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60362356 LIMIT 2 [ RunTime:0.046451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60362356 ORDER BY `minOrder` ASC [ RunTime:0.010671s ]
select * from pdf where partno='643067-9' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.018545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '643067-9' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.033296s ]
SELECT `id` FROM `stock` WHERE `id` <> 60362356 AND `partno` = '643067-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.028602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612960 [ RunTime:0.017160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60362337 LIMIT 5 [ RunTime:0.016652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60362337 ORDER BY `minOrder` ASC [ RunTime:0.003204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60362337 ORDER BY `unit` DESC [ RunTime:0.010874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60362337 LIMIT 2 [ RunTime:0.031924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60362337 ORDER BY `minOrder` ASC [ RunTime:0.014821s ]
select * from pdf where partno='643067-7' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.027307s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '643067-7' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.020416s ]
SELECT `id` FROM `stock` WHERE `id` <> 60362337 AND `partno` = '643067-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.045451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613176 [ RunTime:0.038681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61147709 LIMIT 5 [ RunTime:0.026390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61147709 ORDER BY `minOrder` ASC [ RunTime:0.022718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61147709 ORDER BY `unit` DESC [ RunTime:0.009619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61147709 LIMIT 2 [ RunTime:0.041436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61147709 ORDER BY `minOrder` ASC [ RunTime:0.011255s ]
select * from pdf where partno='643060100604' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.043342s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '643060100604' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.027593s ]
SELECT `id` FROM `stock` WHERE `id` <> 61147709 AND `partno` = '643060100604' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.039269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10862668 [ RunTime:0.031823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61147742 LIMIT 5 [ RunTime:0.029175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61147742 ORDER BY `minOrder` ASC [ RunTime:0.082450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61147742 ORDER BY `unit` DESC [ RunTime:0.048614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61147742 LIMIT 2 [ RunTime:0.003770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61147742 ORDER BY `minOrder` ASC [ RunTime:0.026870s ]
select * from pdf where partno='643060100605' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.014346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '643060100605' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.031499s ]
SELECT `id` FROM `stock` WHERE `id` <> 61147742 AND `partno` = '643060100605' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.035005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10863697 [ RunTime:0.046660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58546271 LIMIT 5 [ RunTime:0.023450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58546271 ORDER BY `minOrder` ASC [ RunTime:0.024138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58546271 ORDER BY `unit` DESC [ RunTime:0.009949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58546271 LIMIT 2 [ RunTime:0.024777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58546271 ORDER BY `minOrder` ASC [ RunTime:0.007789s ]
select * from pdf where partno='64306' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.008188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '64306' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.022236s ]
SELECT `id` FROM `stock` WHERE `id` <> 58546271 AND `partno` = '64306' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.010727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61194232 LIMIT 5 [ RunTime:0.045301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61194232 ORDER BY `minOrder` ASC [ RunTime:0.076858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61194232 ORDER BY `unit` DESC [ RunTime:0.016150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61194232 LIMIT 2 [ RunTime:0.009202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61194232 ORDER BY `minOrder` ASC [ RunTime:0.019782s ]
select * from pdf where partno='643060100608' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.013773s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '643060100608' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.008466s ]
SELECT `id` FROM `stock` WHERE `id` <> 61194232 AND `partno` = '643060100608' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.022896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10865917 [ RunTime:0.018413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44008876 LIMIT 5 [ RunTime:0.041692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44008876 ORDER BY `minOrder` ASC [ RunTime:0.043957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44008876 ORDER BY `unit` DESC [ RunTime:0.013802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44008876 LIMIT 2 [ RunTime:0.036250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44008876 ORDER BY `minOrder` ASC [ RunTime:0.017245s ]
select * from pdf where partno='643064' and brandshort='Astro Tool Corp' limit 1 [ RunTime:0.037573s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '643064' OR `brand` LIKE 'Astro Tool Corp%' ) ) LIMIT 1 [ RunTime:0.018759s ]
SELECT `id` FROM `stock` WHERE `id` <> 44008876 AND `partno` = '643064' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%astro tool corp%' ) [ RunTime:0.034114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15216347 [ RunTime:0.026861s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '64306%' OR `brand` LIKE '64306%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050691s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '64306%' OR `brand` LIKE '64306%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057297s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '64306%' OR `brand` LIKE '64306%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033533s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '64306%' OR `brand` LIKE '64306%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041338s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '64306%' OR `brand` LIKE '64306%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045724s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '64306%' OR `brand` LIKE '64306%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031921s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '64306%' OR `brand` LIKE '64306%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060498s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '64306%' OR `brand` LIKE '64306%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.078235s ]