SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002022s ]
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=21020&search=1' [ RunTime:0.005243s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001813s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.013349s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002708s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.001928s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001918s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000556s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002012s ]
SELECT * FROM `stock_search` WHERE `partno` = '21020' LIMIT 1 [ RunTime:0.002872s ]
UPDATE `stock_search` SET `count` = 9 , `updatetime` = '2026-08-27 15:58:50' WHERE `partno` = '21020' [ RunTime:0.011125s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002060s ]
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 '21020%' OR `brand` LIKE '21020%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017806s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11529990 LIMIT 5 [ RunTime:0.008285s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11529990 ORDER BY `minOrder` ASC [ RunTime:0.004173s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.012395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11529990 ORDER BY `unit` DESC [ RunTime:0.012180s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11529990 LIMIT 2 [ RunTime:0.002764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11529990 ORDER BY `minOrder` ASC [ RunTime:0.008404s ]
select * from pdf where partno='2102061-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.017304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19846113 LIMIT 5 [ RunTime:0.017460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19846113 ORDER BY `minOrder` ASC [ RunTime:0.016156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19846113 ORDER BY `unit` DESC [ RunTime:0.000484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19846113 LIMIT 2 [ RunTime:0.010602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19846113 ORDER BY `minOrder` ASC [ RunTime:0.000704s ]
select * from pdf where partno='2102060-3' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.007466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16208399 LIMIT 5 [ RunTime:0.006819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16208399 ORDER BY `minOrder` ASC [ RunTime:0.003732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16208399 ORDER BY `unit` DESC [ RunTime:0.003141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16208399 LIMIT 2 [ RunTime:0.004029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16208399 ORDER BY `minOrder` ASC [ RunTime:0.000182s ]
select * from pdf where partno='2102060-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.000884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15481975 LIMIT 5 [ RunTime:0.006933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15481975 ORDER BY `minOrder` ASC [ RunTime:0.001176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15481975 ORDER BY `unit` DESC [ RunTime:0.011177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15481975 LIMIT 2 [ RunTime:0.001086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15481975 ORDER BY `minOrder` ASC [ RunTime:0.002195s ]
select * from pdf where partno='2102060-4' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.001860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16197347 LIMIT 5 [ RunTime:0.002466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197347 ORDER BY `minOrder` ASC [ RunTime:0.000772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16197347 ORDER BY `unit` DESC [ RunTime:0.011617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16197347 LIMIT 2 [ RunTime:0.028529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197347 ORDER BY `minOrder` ASC [ RunTime:0.002387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12680511 LIMIT 5 [ RunTime:0.009907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12680511 ORDER BY `minOrder` ASC [ RunTime:0.001559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12680511 ORDER BY `unit` DESC [ RunTime:0.011936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12680511 LIMIT 2 [ RunTime:0.007073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12680511 ORDER BY `minOrder` ASC [ RunTime:0.002642s ]
select * from pdf where partno='2102061-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.003141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12665826 LIMIT 5 [ RunTime:0.004616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12665826 ORDER BY `minOrder` ASC [ RunTime:0.003587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12665826 ORDER BY `unit` DESC [ RunTime:0.000434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12665826 LIMIT 2 [ RunTime:0.007969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12665826 ORDER BY `minOrder` ASC [ RunTime:0.002033s ]
select * from pdf where partno='2102061-9' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.004657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12687603 LIMIT 5 [ RunTime:0.005157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12687603 ORDER BY `minOrder` ASC [ RunTime:0.020022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12687603 ORDER BY `unit` DESC [ RunTime:0.007095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12687603 LIMIT 2 [ RunTime:0.002600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12687603 ORDER BY `minOrder` ASC [ RunTime:0.000299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11529987 LIMIT 5 [ RunTime:0.000909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11529987 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11529987 ORDER BY `unit` DESC [ RunTime:0.000358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11529987 LIMIT 2 [ RunTime:0.011151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11529987 ORDER BY `minOrder` ASC [ RunTime:0.000379s ]
select * from pdf where partno='2102061-3' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.001453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12680512 LIMIT 5 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12680512 ORDER BY `minOrder` ASC [ RunTime:0.003092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12680512 ORDER BY `unit` DESC [ RunTime:0.002899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12680512 LIMIT 2 [ RunTime:0.010043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12680512 ORDER BY `minOrder` ASC [ RunTime:0.010121s ]
select * from pdf where partno='2102061-4' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.008475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19763193 LIMIT 5 [ RunTime:0.006157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19763193 ORDER BY `minOrder` ASC [ RunTime:0.003053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19763193 ORDER BY `unit` DESC [ RunTime:0.000775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19763193 LIMIT 2 [ RunTime:0.002952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19763193 ORDER BY `minOrder` ASC [ RunTime:0.005012s ]
select * from pdf where partno='2102060-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.001185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842923 LIMIT 5 [ RunTime:0.002483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842923 ORDER BY `minOrder` ASC [ RunTime:0.006291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18842923 ORDER BY `unit` DESC [ RunTime:0.019957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18842923 LIMIT 2 [ RunTime:0.011848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842923 ORDER BY `minOrder` ASC [ RunTime:0.004688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18700736 LIMIT 5 [ RunTime:0.001181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700736 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18700736 ORDER BY `unit` DESC [ RunTime:0.009544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18700736 LIMIT 2 [ RunTime:0.001261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700736 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17297123 LIMIT 5 [ RunTime:0.003184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17297123 ORDER BY `minOrder` ASC [ RunTime:0.012862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17297123 ORDER BY `unit` DESC [ RunTime:0.008972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17297123 LIMIT 2 [ RunTime:0.005624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17297123 ORDER BY `minOrder` ASC [ RunTime:0.002966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325594 LIMIT 5 [ RunTime:0.000793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325594 ORDER BY `minOrder` ASC [ RunTime:0.000404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325594 ORDER BY `unit` DESC [ RunTime:0.011143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325594 LIMIT 2 [ RunTime:0.002083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325594 ORDER BY `minOrder` ASC [ RunTime:0.006673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13299875 LIMIT 5 [ RunTime:0.000784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13299875 ORDER BY `minOrder` ASC [ RunTime:0.005985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13299875 ORDER BY `unit` DESC [ RunTime:0.007776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13299875 LIMIT 2 [ RunTime:0.004339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13299875 ORDER BY `minOrder` ASC [ RunTime:0.002548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13291355 LIMIT 5 [ RunTime:0.006232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13291355 ORDER BY `minOrder` ASC [ RunTime:0.010685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13291355 ORDER BY `unit` DESC [ RunTime:0.019279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13291355 LIMIT 2 [ RunTime:0.003249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13291355 ORDER BY `minOrder` ASC [ RunTime:0.003101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13291353 LIMIT 5 [ RunTime:0.008761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13291353 ORDER BY `minOrder` ASC [ RunTime:0.006995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13291353 ORDER BY `unit` DESC [ RunTime:0.024612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13291353 LIMIT 2 [ RunTime:0.024681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13291353 ORDER BY `minOrder` ASC [ RunTime:0.030787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13286459 LIMIT 5 [ RunTime:0.019540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13286459 ORDER BY `minOrder` ASC [ RunTime:0.064396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13286459 ORDER BY `unit` DESC [ RunTime:0.053273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13286459 LIMIT 2 [ RunTime:0.025046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13286459 ORDER BY `minOrder` ASC [ RunTime:0.021284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13164982 LIMIT 5 [ RunTime:0.014786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13164982 ORDER BY `minOrder` ASC [ RunTime:0.031861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13164982 ORDER BY `unit` DESC [ RunTime:0.058795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13164982 LIMIT 2 [ RunTime:0.030313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13164982 ORDER BY `minOrder` ASC [ RunTime:0.018903s ]
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 '21020%' OR `brand` LIKE '21020%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32215019 LIMIT 5 [ RunTime:0.039762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32215019 ORDER BY `minOrder` ASC [ RunTime:0.030809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32215019 ORDER BY `unit` DESC [ RunTime:0.014804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32215019 LIMIT 2 [ RunTime:0.001959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32215019 ORDER BY `minOrder` ASC [ RunTime:0.004296s ]
select * from pdf where partno='21020-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.014186s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21020-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.035722s ]
SELECT `id` FROM `stock` WHERE `id` <> 32215019 AND `partno` = '21020-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.032516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32164328 [ RunTime:0.055089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32164328 LIMIT 5 [ RunTime:0.013070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32164328 ORDER BY `minOrder` ASC [ RunTime:0.019478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32164328 ORDER BY `unit` DESC [ RunTime:0.039003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32164328 LIMIT 2 [ RunTime:0.024114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32164328 ORDER BY `minOrder` ASC [ RunTime:0.012002s ]
select * from pdf where partno='21020-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.019278s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21020-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.005510s ]
SELECT `id` FROM `stock` WHERE `id` <> 32164328 AND `partno` = '21020-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.015416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32215019 [ RunTime:0.024151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270391 LIMIT 5 [ RunTime:0.044167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270391 ORDER BY `minOrder` ASC [ RunTime:0.015471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270391 ORDER BY `unit` DESC [ RunTime:0.057318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270391 LIMIT 2 [ RunTime:0.011367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270391 ORDER BY `minOrder` ASC [ RunTime:0.013743s ]
select * from pdf where partno='2102081-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.023648s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102081-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.022328s ]
SELECT `id` FROM `stock` WHERE `id` <> 32270391 AND `partno` = '2102081-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.031764s ]
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 '21020%' OR `brand` LIKE '21020%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59435671 LIMIT 5 [ RunTime:0.012306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59435671 ORDER BY `minOrder` ASC [ RunTime:0.053169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59435671 ORDER BY `unit` DESC [ RunTime:0.025984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59435671 LIMIT 2 [ RunTime:0.025916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59435671 ORDER BY `minOrder` ASC [ RunTime:0.011312s ]
select * from pdf where partno='2102060-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.010263s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102060-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.024580s ]
SELECT `id` FROM `stock` WHERE `id` <> 59435671 AND `partno` = '2102060-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.016434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19763193 [ RunTime:0.003257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59751183 LIMIT 5 [ RunTime:0.013731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59751183 ORDER BY `minOrder` ASC [ RunTime:0.039521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59751183 ORDER BY `unit` DESC [ RunTime:0.018121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59751183 LIMIT 2 [ RunTime:0.024131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59751183 ORDER BY `minOrder` ASC [ RunTime:0.001714s ]
select * from pdf where partno='2102061-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.023271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102061-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.055817s ]
SELECT `id` FROM `stock` WHERE `id` <> 59751183 AND `partno` = '2102061-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.022070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11529990 [ RunTime:0.073403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59359574 LIMIT 5 [ RunTime:0.048696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59359574 ORDER BY `minOrder` ASC [ RunTime:0.019045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59359574 ORDER BY `unit` DESC [ RunTime:0.019519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59359574 LIMIT 2 [ RunTime:0.052328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59359574 ORDER BY `minOrder` ASC [ RunTime:0.042138s ]
select * from pdf where partno='2102079-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.030803s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102079-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.033095s ]
SELECT `id` FROM `stock` WHERE `id` <> 59359574 AND `partno` = '2102079-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.046479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12793808 [ RunTime:0.039113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59767678 LIMIT 5 [ RunTime:0.023227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59767678 ORDER BY `minOrder` ASC [ RunTime:0.013921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59767678 ORDER BY `unit` DESC [ RunTime:0.057898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59767678 LIMIT 2 [ RunTime:0.047979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59767678 ORDER BY `minOrder` ASC [ RunTime:0.065035s ]
select * from pdf where partno='2102080-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.048049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102080-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.028210s ]
SELECT `id` FROM `stock` WHERE `id` <> 59767678 AND `partno` = '2102080-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.101586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59435670 LIMIT 5 [ RunTime:0.040088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59435670 ORDER BY `minOrder` ASC [ RunTime:0.028863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59435670 ORDER BY `unit` DESC [ RunTime:0.043490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59435670 LIMIT 2 [ RunTime:0.025078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59435670 ORDER BY `minOrder` ASC [ RunTime:0.013300s ]
select * from pdf where partno='2102060-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.002783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102060-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.001956s ]
SELECT `id` FROM `stock` WHERE `id` <> 59435670 AND `partno` = '2102060-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.005443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16208399 [ RunTime:0.012024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59442038 LIMIT 5 [ RunTime:0.020950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442038 ORDER BY `minOrder` ASC [ RunTime:0.001960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59442038 ORDER BY `unit` DESC [ RunTime:0.008965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59442038 LIMIT 2 [ RunTime:0.007981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442038 ORDER BY `minOrder` ASC [ RunTime:0.003967s ]
select * from pdf where partno='2102079-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.011093s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102079-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.027997s ]
SELECT `id` FROM `stock` WHERE `id` <> 59442038 AND `partno` = '2102079-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.013421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16197347 [ RunTime:0.000575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59442048 LIMIT 5 [ RunTime:0.012637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442048 ORDER BY `minOrder` ASC [ RunTime:0.006023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59442048 ORDER BY `unit` DESC [ RunTime:0.002166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59442048 LIMIT 2 [ RunTime:0.022948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442048 ORDER BY `minOrder` ASC [ RunTime:0.000792s ]
select * from pdf where partno='2102060-4' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.007283s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102060-4' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.012869s ]
SELECT `id` FROM `stock` WHERE `id` <> 59442048 AND `partno` = '2102060-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.006997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15481975 [ RunTime:0.001983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59749023 LIMIT 5 [ RunTime:0.002350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59749023 ORDER BY `minOrder` ASC [ RunTime:0.016325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59749023 ORDER BY `unit` DESC [ RunTime:0.015001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59749023 LIMIT 2 [ RunTime:0.011006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59749023 ORDER BY `minOrder` ASC [ RunTime:0.004542s ]
select * from pdf where partno='2102061-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.006530s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102061-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.000954s ]
SELECT `id` FROM `stock` WHERE `id` <> 59749023 AND `partno` = '2102061-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.005178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12680511 [ RunTime:0.007659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64445113 LIMIT 5 [ RunTime:0.007931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445113 ORDER BY `minOrder` ASC [ RunTime:0.003112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64445113 ORDER BY `unit` DESC [ RunTime:0.000958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64445113 LIMIT 2 [ RunTime:0.005272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445113 ORDER BY `minOrder` ASC [ RunTime:0.001088s ]
select * from pdf where partno='21020000' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.012566s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21020000' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.006174s ]
SELECT `id` FROM `stock` WHERE `id` <> 64445113 AND `partno` = '21020000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.013362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842923 [ RunTime:0.016270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63373249 LIMIT 5 [ RunTime:0.012064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63373249 ORDER BY `minOrder` ASC [ RunTime:0.010111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63373249 ORDER BY `unit` DESC [ RunTime:0.020071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63373249 LIMIT 2 [ RunTime:0.017673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63373249 ORDER BY `minOrder` ASC [ RunTime:0.016291s ]
select * from pdf where partno='21020-3' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.009441s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21020-3' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.015071s ]
SELECT `id` FROM `stock` WHERE `id` <> 63373249 AND `partno` = '21020-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.019795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60960063 LIMIT 5 [ RunTime:0.071941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60960063 ORDER BY `minOrder` ASC [ RunTime:0.039889s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60960063 ORDER BY `unit` DESC [ RunTime:0.061638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60960063 LIMIT 2 [ RunTime:0.013554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60960063 ORDER BY `minOrder` ASC [ RunTime:0.008823s ]
select * from pdf where partno='2102096-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.005603s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102096-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.017441s ]
SELECT `id` FROM `stock` WHERE `id` <> 60960063 AND `partno` = '2102096-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.028384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11400636 [ RunTime:0.040047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60958887 LIMIT 5 [ RunTime:0.079039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60958887 ORDER BY `minOrder` ASC [ RunTime:0.047988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60958887 ORDER BY `unit` DESC [ RunTime:0.039048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60958887 LIMIT 2 [ RunTime:0.055683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60958887 ORDER BY `minOrder` ASC [ RunTime:0.013134s ]
select * from pdf where partno='2102087-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.037364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102087-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.066346s ]
SELECT `id` FROM `stock` WHERE `id` <> 60958887 AND `partno` = '2102087-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.057001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11400231 [ RunTime:0.037943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60958882 LIMIT 5 [ RunTime:0.013674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60958882 ORDER BY `minOrder` ASC [ RunTime:0.008640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60958882 ORDER BY `unit` DESC [ RunTime:0.033225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60958882 LIMIT 2 [ RunTime:0.017129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60958882 ORDER BY `minOrder` ASC [ RunTime:0.014490s ]
select * from pdf where partno='2102086-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.045635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102086-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.017270s ]
SELECT `id` FROM `stock` WHERE `id` <> 60958882 AND `partno` = '2102086-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.047444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11400230 [ RunTime:0.042086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60958813 LIMIT 5 [ RunTime:0.013463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60958813 ORDER BY `minOrder` ASC [ RunTime:0.037939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60958813 ORDER BY `unit` DESC [ RunTime:0.074838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60958813 LIMIT 2 [ RunTime:0.043239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60958813 ORDER BY `minOrder` ASC [ RunTime:0.039558s ]
select * from pdf where partno='2102081-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.118972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102081-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.106016s ]
SELECT `id` FROM `stock` WHERE `id` <> 60958813 AND `partno` = '2102081-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.080721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12495041 [ RunTime:0.034729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60958812 LIMIT 5 [ RunTime:0.065073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60958812 ORDER BY `minOrder` ASC [ RunTime:0.094629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60958812 ORDER BY `unit` DESC [ RunTime:0.143457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60958812 LIMIT 2 [ RunTime:0.109493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60958812 ORDER BY `minOrder` ASC [ RunTime:0.043932s ]
select * from pdf where partno='2102081-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.071156s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102081-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.035370s ]
SELECT `id` FROM `stock` WHERE `id` <> 60958812 AND `partno` = '2102081-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.055881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12495042 [ RunTime:0.059412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60958266 LIMIT 5 [ RunTime:0.027011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60958266 ORDER BY `minOrder` ASC [ RunTime:0.132689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60958266 ORDER BY `unit` DESC [ RunTime:0.078210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60958266 LIMIT 2 [ RunTime:0.033166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60958266 ORDER BY `minOrder` ASC [ RunTime:0.091984s ]
select * from pdf where partno='2102086-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.045524s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102086-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.047060s ]
SELECT `id` FROM `stock` WHERE `id` <> 60958266 AND `partno` = '2102086-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.019354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60958242 LIMIT 5 [ RunTime:0.043761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60958242 ORDER BY `minOrder` ASC [ RunTime:0.073802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60958242 ORDER BY `unit` DESC [ RunTime:0.030809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60958242 LIMIT 2 [ RunTime:0.065827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60958242 ORDER BY `minOrder` ASC [ RunTime:0.022157s ]
select * from pdf where partno='2102087-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.047403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102087-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.080397s ]
SELECT `id` FROM `stock` WHERE `id` <> 60958242 AND `partno` = '2102087-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.057207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12494796 [ RunTime:0.127299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60958241 LIMIT 5 [ RunTime:0.038934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60958241 ORDER BY `minOrder` ASC [ RunTime:0.149311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60958241 ORDER BY `unit` DESC [ RunTime:0.085252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60958241 LIMIT 2 [ RunTime:0.134924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60958241 ORDER BY `minOrder` ASC [ RunTime:0.057386s ]
select * from pdf where partno='2102088-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.100178s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102088-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.036013s ]
SELECT `id` FROM `stock` WHERE `id` <> 60958241 AND `partno` = '2102088-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.134208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11399844 [ RunTime:0.072769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60957266 LIMIT 5 [ RunTime:0.090862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60957266 ORDER BY `minOrder` ASC [ RunTime:0.033197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60957266 ORDER BY `unit` DESC [ RunTime:0.060662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60957266 LIMIT 2 [ RunTime:0.043066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60957266 ORDER BY `minOrder` ASC [ RunTime:0.003645s ]
select * from pdf where partno='2102098-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.057024s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102098-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.044020s ]
SELECT `id` FROM `stock` WHERE `id` <> 60957266 AND `partno` = '2102098-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.065108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60954494 LIMIT 5 [ RunTime:0.019050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60954494 ORDER BY `minOrder` ASC [ RunTime:0.038133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60954494 ORDER BY `unit` DESC [ RunTime:0.074680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60954494 LIMIT 2 [ RunTime:0.124554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60954494 ORDER BY `minOrder` ASC [ RunTime:0.030655s ]
select * from pdf where partno='2102094-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.034178s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102094-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.026140s ]
SELECT `id` FROM `stock` WHERE `id` <> 60954494 AND `partno` = '2102094-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.132050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12493298 [ RunTime:0.072465s ]
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 '21020%' OR `brand` LIKE '21020%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.093433s ]
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 '21020%' OR `brand` LIKE '21020%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016152s ]
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 '21020%' OR `brand` LIKE '21020%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040623s ]
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 '21020%' OR `brand` LIKE '21020%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.056922s ]
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 '21020%' OR `brand` LIKE '21020%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026968s ]
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 '21020%' OR `brand` LIKE '21020%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021095s ]
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 '21020%' OR `brand` LIKE '21020%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051403s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '21020%' OR `brand` LIKE '21020%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.052382s ]