SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001684s ]
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=5710&search=1' [ RunTime:0.011195s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001377s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.008748s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002585s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.015825s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001674s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005899s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003740s ]
SELECT * FROM `stock_search` WHERE `partno` = '5710' LIMIT 1 [ RunTime:0.009550s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-21 20:58:14' WHERE `partno` = '5710' [ RunTime:0.001799s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002646s ]
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 '5710%' OR `brand` LIKE '5710%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.056042s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19750874 LIMIT 5 [ RunTime:0.043772s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19750874 ORDER BY `minOrder` ASC [ RunTime:0.026137s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19750874 ORDER BY `unit` DESC [ RunTime:0.014203s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19750874 LIMIT 2 [ RunTime:0.036320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19750874 ORDER BY `minOrder` ASC [ RunTime:0.010246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16182740 LIMIT 5 [ RunTime:0.020351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16182740 ORDER BY `minOrder` ASC [ RunTime:0.030311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16182740 ORDER BY `unit` DESC [ RunTime:0.006455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16182740 LIMIT 2 [ RunTime:0.049476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16182740 ORDER BY `minOrder` ASC [ RunTime:0.000517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15249566 LIMIT 5 [ RunTime:0.031921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15249566 ORDER BY `minOrder` ASC [ RunTime:0.033799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15249566 ORDER BY `unit` DESC [ RunTime:0.029954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15249566 LIMIT 2 [ RunTime:0.019452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15249566 ORDER BY `minOrder` ASC [ RunTime:0.020749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19153220 LIMIT 5 [ RunTime:0.027645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19153220 ORDER BY `minOrder` ASC [ RunTime:0.039751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19153220 ORDER BY `unit` DESC [ RunTime:0.026755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19153220 LIMIT 2 [ RunTime:0.051284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19153220 ORDER BY `minOrder` ASC [ RunTime:0.038057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19748398 LIMIT 5 [ RunTime:0.023767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19748398 ORDER BY `minOrder` ASC [ RunTime:0.029660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19748398 ORDER BY `unit` DESC [ RunTime:0.031514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19748398 LIMIT 2 [ RunTime:0.005290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19748398 ORDER BY `minOrder` ASC [ RunTime:0.012568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15249567 LIMIT 5 [ RunTime:0.037162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15249567 ORDER BY `minOrder` ASC [ RunTime:0.004421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15249567 ORDER BY `unit` DESC [ RunTime:0.038029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15249567 LIMIT 2 [ RunTime:0.023081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15249567 ORDER BY `minOrder` ASC [ RunTime:0.016096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16196843 LIMIT 5 [ RunTime:0.010287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16196843 ORDER BY `minOrder` ASC [ RunTime:0.005504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16196843 ORDER BY `unit` DESC [ RunTime:0.005812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16196843 LIMIT 2 [ RunTime:0.017285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16196843 ORDER BY `minOrder` ASC [ RunTime:0.015424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19834452 LIMIT 5 [ RunTime:0.013397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19834452 ORDER BY `minOrder` ASC [ RunTime:0.011997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19834452 ORDER BY `unit` DESC [ RunTime:0.011992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19834452 LIMIT 2 [ RunTime:0.016395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19834452 ORDER BY `minOrder` ASC [ RunTime:0.001900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17034087 LIMIT 5 [ RunTime:0.006421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17034087 ORDER BY `minOrder` ASC [ RunTime:0.033422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17034087 ORDER BY `unit` DESC [ RunTime:0.032657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17034087 LIMIT 2 [ RunTime:0.008254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17034087 ORDER BY `minOrder` ASC [ RunTime:0.001132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19850543 LIMIT 5 [ RunTime:0.014377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19850543 ORDER BY `minOrder` ASC [ RunTime:0.025764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19850543 ORDER BY `unit` DESC [ RunTime:0.032246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19850543 LIMIT 2 [ RunTime:0.004086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19850543 ORDER BY `minOrder` ASC [ RunTime:0.002575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19851232 LIMIT 5 [ RunTime:0.021501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19851232 ORDER BY `minOrder` ASC [ RunTime:0.002041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19851232 ORDER BY `unit` DESC [ RunTime:0.004847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19851232 LIMIT 2 [ RunTime:0.001447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19851232 ORDER BY `minOrder` ASC [ RunTime:0.011328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19830659 LIMIT 5 [ RunTime:0.002486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19830659 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19830659 ORDER BY `unit` DESC [ RunTime:0.001838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19830659 LIMIT 2 [ RunTime:0.012703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19830659 ORDER BY `minOrder` ASC [ RunTime:0.003948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904020 LIMIT 5 [ RunTime:0.015211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904020 ORDER BY `minOrder` ASC [ RunTime:0.002394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18904020 ORDER BY `unit` DESC [ RunTime:0.002543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18904020 LIMIT 2 [ RunTime:0.007562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904020 ORDER BY `minOrder` ASC [ RunTime:0.007039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19773721 LIMIT 5 [ RunTime:0.001043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19773721 ORDER BY `minOrder` ASC [ RunTime:0.002413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19773721 ORDER BY `unit` DESC [ RunTime:0.000377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19773721 LIMIT 2 [ RunTime:0.000341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19773721 ORDER BY `minOrder` ASC [ RunTime:0.000245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16196594 LIMIT 5 [ RunTime:0.000727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16196594 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16196594 ORDER BY `unit` DESC [ RunTime:0.005006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16196594 LIMIT 2 [ RunTime:0.001687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16196594 ORDER BY `minOrder` ASC [ RunTime:0.001693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17034344 LIMIT 5 [ RunTime:0.000640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17034344 ORDER BY `minOrder` ASC [ RunTime:0.002776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17034344 ORDER BY `unit` DESC [ RunTime:0.004304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17034344 LIMIT 2 [ RunTime:0.000335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17034344 ORDER BY `minOrder` ASC [ RunTime:0.000235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19851099 LIMIT 5 [ RunTime:0.000644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19851099 ORDER BY `minOrder` ASC [ RunTime:0.000912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19851099 ORDER BY `unit` DESC [ RunTime:0.000316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19851099 LIMIT 2 [ RunTime:0.000313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19851099 ORDER BY `minOrder` ASC [ RunTime:0.001452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15250538 LIMIT 5 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15250538 ORDER BY `minOrder` ASC [ RunTime:0.000864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15250538 ORDER BY `unit` DESC [ RunTime:0.001357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15250538 LIMIT 2 [ RunTime:0.000803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15250538 ORDER BY `minOrder` ASC [ RunTime:0.003728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16015024 LIMIT 5 [ RunTime:0.000738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16015024 ORDER BY `minOrder` ASC [ RunTime:0.000368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16015024 ORDER BY `unit` DESC [ RunTime:0.002446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16015024 LIMIT 2 [ RunTime:0.003067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16015024 ORDER BY `minOrder` ASC [ RunTime:0.005950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19773706 LIMIT 5 [ RunTime:0.003371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19773706 ORDER BY `minOrder` ASC [ RunTime:0.006553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19773706 ORDER BY `unit` DESC [ RunTime:0.001694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19773706 LIMIT 2 [ RunTime:0.000443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19773706 ORDER BY `minOrder` ASC [ RunTime:0.000287s ]
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 '5710%' OR `brand` LIKE '5710%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51081190 LIMIT 5 [ RunTime:0.003106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51081190 ORDER BY `minOrder` ASC [ RunTime:0.008826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51081190 ORDER BY `unit` DESC [ RunTime:0.010584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51081190 LIMIT 2 [ RunTime:0.000565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51081190 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
select * from pdf where partno='57105-000' and brandshort='littelfuse' limit 1 [ RunTime:0.006417s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57105-000' OR `brand` LIKE 'littelfuse%' ) ) LIMIT 1 [ RunTime:0.012125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32212690 LIMIT 5 [ RunTime:0.019366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212690 ORDER BY `minOrder` ASC [ RunTime:0.017166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32212690 ORDER BY `unit` DESC [ RunTime:0.010913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32212690 LIMIT 2 [ RunTime:0.001049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212690 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
select * from pdf where partno='5710e' and brandshort='ohmite' limit 1 [ RunTime:0.001112s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5710e' OR `brand` LIKE 'ohmite%' ) ) LIMIT 1 [ RunTime:0.003850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51088703 LIMIT 5 [ RunTime:0.005243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51088703 ORDER BY `minOrder` ASC [ RunTime:0.017784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51088703 ORDER BY `unit` DESC [ RunTime:0.000985s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51088703 LIMIT 2 [ RunTime:0.007792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51088703 ORDER BY `minOrder` ASC [ RunTime:0.011582s ]
select * from pdf where partno='57105' and brandshort='murrelektronik' limit 1 [ RunTime:0.017296s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57105' OR `brand` LIKE 'murrelektronik%' ) ) LIMIT 1 [ RunTime:0.014814s ]
SELECT `id` FROM `stock` WHERE `id` <> 51088703 AND `partno` = '57105' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik%' ) [ RunTime:0.008660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32672456 [ RunTime:0.002958s ]
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 '5710%' OR `brand` LIKE '5710%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58199242 LIMIT 5 [ RunTime:0.003856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58199242 ORDER BY `minOrder` ASC [ RunTime:0.011970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58199242 ORDER BY `unit` DESC [ RunTime:0.009202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58199242 LIMIT 2 [ RunTime:0.009314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58199242 ORDER BY `minOrder` ASC [ RunTime:0.001062s ]
select * from pdf where partno='57100000001' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.006423s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57100000001' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59442838 LIMIT 5 [ RunTime:0.000491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442838 ORDER BY `minOrder` ASC [ RunTime:0.001672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59442838 ORDER BY `unit` DESC [ RunTime:0.010019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59442838 LIMIT 2 [ RunTime:0.000753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59442838 ORDER BY `minOrder` ASC [ RunTime:0.003368s ]
select * from pdf where partno='57102-G06-03LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.004742s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57102-G06-03LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000788s ]
SELECT `id` FROM `stock` WHERE `id` <> 59442838 AND `partno` = '57102-G06-03LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.001973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19851232 [ RunTime:0.014302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59438430 LIMIT 5 [ RunTime:0.011136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59438430 ORDER BY `minOrder` ASC [ RunTime:0.017152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59438430 ORDER BY `unit` DESC [ RunTime:0.008275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59438430 LIMIT 2 [ RunTime:0.002820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59438430 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
select * from pdf where partno='57102-G06-05LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57102-G06-05LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.012194s ]
SELECT `id` FROM `stock` WHERE `id` <> 59438430 AND `partno` = '57102-G06-05LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.004568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19748398 [ RunTime:0.003736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59476437 LIMIT 5 [ RunTime:0.005383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59476437 ORDER BY `minOrder` ASC [ RunTime:0.015934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59476437 ORDER BY `unit` DESC [ RunTime:0.010691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59476437 LIMIT 2 [ RunTime:0.009186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59476437 ORDER BY `minOrder` ASC [ RunTime:0.010854s ]
select * from pdf where partno='57102-F08-06ULF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.002851s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57102-F08-06ULF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.001316s ]
SELECT `id` FROM `stock` WHERE `id` <> 59476437 AND `partno` = '57102-F08-06ULF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.006744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19750874 [ RunTime:0.008421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59449433 LIMIT 5 [ RunTime:0.010793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59449433 ORDER BY `minOrder` ASC [ RunTime:0.002858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59449433 ORDER BY `unit` DESC [ RunTime:0.005651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59449433 LIMIT 2 [ RunTime:0.015339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59449433 ORDER BY `minOrder` ASC [ RunTime:0.001462s ]
select * from pdf where partno='57102-G06-08LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.006757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57102-G06-08LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.006582s ]
SELECT `id` FROM `stock` WHERE `id` <> 59449433 AND `partno` = '57102-G06-08LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.029625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16187269 [ RunTime:0.002947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59444637 LIMIT 5 [ RunTime:0.000701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59444637 ORDER BY `minOrder` ASC [ RunTime:0.005549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59444637 ORDER BY `unit` DESC [ RunTime:0.006328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59444637 LIMIT 2 [ RunTime:0.000707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59444637 ORDER BY `minOrder` ASC [ RunTime:0.004340s ]
select * from pdf where partno='57102-F06-08LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.009281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57102-F06-08LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.003877s ]
SELECT `id` FROM `stock` WHERE `id` <> 59444637 AND `partno` = '57102-F06-08LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.001090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16196594 [ RunTime:0.006712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59443697 LIMIT 5 [ RunTime:0.006015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59443697 ORDER BY `minOrder` ASC [ RunTime:0.009490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59443697 ORDER BY `unit` DESC [ RunTime:0.000808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59443697 LIMIT 2 [ RunTime:0.007867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59443697 ORDER BY `minOrder` ASC [ RunTime:0.016102s ]
select * from pdf where partno='57102-F08-07ULF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.005201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57102-F08-07ULF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.015386s ]
SELECT `id` FROM `stock` WHERE `id` <> 59443697 AND `partno` = '57102-F08-07ULF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.007142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16182740 [ RunTime:0.004674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58127330 LIMIT 5 [ RunTime:0.005586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58127330 ORDER BY `minOrder` ASC [ RunTime:0.020930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58127330 ORDER BY `unit` DESC [ RunTime:0.007628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58127330 LIMIT 2 [ RunTime:0.007350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58127330 ORDER BY `minOrder` ASC [ RunTime:0.003463s ]
select * from pdf where partno='5710112F' and brandshort='Dialight' limit 1 [ RunTime:0.001536s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5710112F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.006145s ]
SELECT `id` FROM `stock` WHERE `id` <> 58127330 AND `partno` = '5710112F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.003131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904020 [ RunTime:0.009596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63354962 LIMIT 5 [ RunTime:0.000959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63354962 ORDER BY `minOrder` ASC [ RunTime:0.005979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63354962 ORDER BY `unit` DESC [ RunTime:0.000591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63354962 LIMIT 2 [ RunTime:0.000761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63354962 ORDER BY `minOrder` ASC [ RunTime:0.008278s ]
select * from pdf where partno='57105-000' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57105-000' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.006391s ]
SELECT `id` FROM `stock` WHERE `id` <> 63354962 AND `partno` = '57105-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.001978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19153220 [ RunTime:0.001180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59437705 LIMIT 5 [ RunTime:0.005323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59437705 ORDER BY `minOrder` ASC [ RunTime:0.009344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59437705 ORDER BY `unit` DESC [ RunTime:0.000933s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59437705 LIMIT 2 [ RunTime:0.002670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59437705 ORDER BY `minOrder` ASC [ RunTime:0.004928s ]
select * from pdf where partno='57102-G06-04LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.006644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57102-G06-04LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.003006s ]
SELECT `id` FROM `stock` WHERE `id` <> 59437705 AND `partno` = '57102-G06-04LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.011978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19852635 [ RunTime:0.017352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59527129 LIMIT 5 [ RunTime:0.033376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59527129 ORDER BY `minOrder` ASC [ RunTime:0.008833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59527129 ORDER BY `unit` DESC [ RunTime:0.008071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59527129 LIMIT 2 [ RunTime:0.025033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59527129 ORDER BY `minOrder` ASC [ RunTime:0.017492s ]
select * from pdf where partno='57102-G06-20LF' and brandshort='FCI Deutschland GmbH' limit 1 [ RunTime:0.010028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57102-G06-20LF' OR `brand` LIKE 'FCI Deutschland GmbH%' ) ) LIMIT 1 [ RunTime:0.001842s ]
SELECT `id` FROM `stock` WHERE `id` <> 59527129 AND `partno` = '57102-G06-20LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fci deutschland gmbh%' ) [ RunTime:0.016766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59482904 LIMIT 5 [ RunTime:0.005345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59482904 ORDER BY `minOrder` ASC [ RunTime:0.018001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59482904 ORDER BY `unit` DESC [ RunTime:0.014533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59482904 LIMIT 2 [ RunTime:0.009190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59482904 ORDER BY `minOrder` ASC [ RunTime:0.001394s ]
select * from pdf where partno='57102-S06-25LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001245s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57102-S06-25LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.007596s ]
SELECT `id` FROM `stock` WHERE `id` <> 59482904 AND `partno` = '57102-S06-25LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.016245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19754664 [ RunTime:0.008542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59460049 LIMIT 5 [ RunTime:0.009218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59460049 ORDER BY `minOrder` ASC [ RunTime:0.014791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59460049 ORDER BY `unit` DESC [ RunTime:0.003528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59460049 LIMIT 2 [ RunTime:0.001564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59460049 ORDER BY `minOrder` ASC [ RunTime:0.001246s ]
select * from pdf where partno='57102-G06-04ULF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.004683s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57102-G06-04ULF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.006376s ]
SELECT `id` FROM `stock` WHERE `id` <> 59460049 AND `partno` = '57102-G06-04ULF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.003021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19803937 [ RunTime:0.015064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58127487 LIMIT 5 [ RunTime:0.002928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58127487 ORDER BY `minOrder` ASC [ RunTime:0.022609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58127487 ORDER BY `unit` DESC [ RunTime:0.016384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58127487 LIMIT 2 [ RunTime:0.004418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58127487 ORDER BY `minOrder` ASC [ RunTime:0.000615s ]
select * from pdf where partno='5710132100F' and brandshort='Dialight' limit 1 [ RunTime:0.021460s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5710132100F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.001335s ]
SELECT `id` FROM `stock` WHERE `id` <> 58127487 AND `partno` = '5710132100F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.010243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904157 [ RunTime:0.010417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59467544 LIMIT 5 [ RunTime:0.001455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59467544 ORDER BY `minOrder` ASC [ RunTime:0.003422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59467544 ORDER BY `unit` DESC [ RunTime:0.003369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59467544 LIMIT 2 [ RunTime:0.004261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59467544 ORDER BY `minOrder` ASC [ RunTime:0.005516s ]
select * from pdf where partno='57102-G06-07ULF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001250s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57102-G06-07ULF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.015337s ]
SELECT `id` FROM `stock` WHERE `id` <> 59467544 AND `partno` = '57102-G06-07ULF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.014855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15485835 [ RunTime:0.022527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59444746 LIMIT 5 [ RunTime:0.012551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59444746 ORDER BY `minOrder` ASC [ RunTime:0.004576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59444746 ORDER BY `unit` DESC [ RunTime:0.000709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59444746 LIMIT 2 [ RunTime:0.004325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59444746 ORDER BY `minOrder` ASC [ RunTime:0.005648s ]
select * from pdf where partno='57102-G06-07LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.012992s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57102-G06-07LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.003080s ]
SELECT `id` FROM `stock` WHERE `id` <> 59444746 AND `partno` = '57102-G06-07LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.001630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19830659 [ RunTime:0.000996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59490825 LIMIT 5 [ RunTime:0.000902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59490825 ORDER BY `minOrder` ASC [ RunTime:0.005930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59490825 ORDER BY `unit` DESC [ RunTime:0.013460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59490825 LIMIT 2 [ RunTime:0.017948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59490825 ORDER BY `minOrder` ASC [ RunTime:0.006271s ]
select * from pdf where partno='57102-F08-25ULF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.006369s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57102-F08-25ULF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.016868s ]
SELECT `id` FROM `stock` WHERE `id` <> 59490825 AND `partno` = '57102-F08-25ULF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.007462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16196843 [ RunTime:0.005230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59445441 LIMIT 5 [ RunTime:0.010482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59445441 ORDER BY `minOrder` ASC [ RunTime:0.004327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59445441 ORDER BY `unit` DESC [ RunTime:0.022051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59445441 LIMIT 2 [ RunTime:0.010959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59445441 ORDER BY `minOrder` ASC [ RunTime:0.007107s ]
select * from pdf where partno='57102-G06-10LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001393s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57102-G06-10LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.001200s ]
SELECT `id` FROM `stock` WHERE `id` <> 59445441 AND `partno` = '57102-G06-10LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19834452 [ RunTime:0.000725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59491444 LIMIT 5 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59491444 ORDER BY `minOrder` ASC [ RunTime:0.007289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59491444 ORDER BY `unit` DESC [ RunTime:0.006348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59491444 LIMIT 2 [ RunTime:0.001818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59491444 ORDER BY `minOrder` ASC [ RunTime:0.009869s ]
select * from pdf where partno='57102-G06-16LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001673s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57102-G06-16LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.009261s ]
SELECT `id` FROM `stock` WHERE `id` <> 59491444 AND `partno` = '57102-G06-16LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.004919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19773721 [ RunTime:0.000798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58127488 LIMIT 5 [ RunTime:0.001129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58127488 ORDER BY `minOrder` ASC [ RunTime:0.003700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58127488 ORDER BY `unit` DESC [ RunTime:0.000623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58127488 LIMIT 2 [ RunTime:0.000988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58127488 ORDER BY `minOrder` ASC [ RunTime:0.002916s ]
select * from pdf where partno='5710123F' and brandshort='Dialight' limit 1 [ RunTime:0.005452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5710123F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.004101s ]
SELECT `id` FROM `stock` WHERE `id` <> 58127488 AND `partno` = '5710123F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.003706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15250538 [ RunTime:0.010041s ]
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 '5710%' OR `brand` LIKE '5710%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001789s ]
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 '5710%' OR `brand` LIKE '5710%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008615s ]
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 '5710%' OR `brand` LIKE '5710%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006951s ]
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 '5710%' OR `brand` LIKE '5710%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008972s ]
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 '5710%' OR `brand` LIKE '5710%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001200s ]
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 '5710%' OR `brand` LIKE '5710%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004863s ]
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 '5710%' OR `brand` LIKE '5710%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004560s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5710%' OR `brand` LIKE '5710%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.012550s ]