SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002436s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.37' , `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=119215&search=1' [ RunTime:0.005285s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002868s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.006194s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002248s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.37' ) [ RunTime:0.004501s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002002s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.017039s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002015s ]
SELECT * FROM `stock_search` WHERE `partno` = '119215' LIMIT 1 [ RunTime:0.041295s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-31 15:36:01' WHERE `partno` = '119215' [ RunTime:0.004224s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002889s ]
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 '119215%' OR `brand` LIKE '119215%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052050s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.031937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14687421 LIMIT 5 [ RunTime:0.021940s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14687421 ORDER BY `minOrder` ASC [ RunTime:0.075391s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14687421 ORDER BY `unit` DESC [ RunTime:0.009533s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14687421 LIMIT 2 [ RunTime:0.043320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14687421 ORDER BY `minOrder` ASC [ RunTime:0.051315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14676622 LIMIT 5 [ RunTime:0.051316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14676622 ORDER BY `minOrder` ASC [ RunTime:0.040174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14676622 ORDER BY `unit` DESC [ RunTime:0.044129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14676622 LIMIT 2 [ RunTime:0.072649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14676622 ORDER BY `minOrder` ASC [ RunTime:0.037902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14676638 LIMIT 5 [ RunTime:0.063245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14676638 ORDER BY `minOrder` ASC [ RunTime:0.031518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14676638 ORDER BY `unit` DESC [ RunTime:0.067616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14676638 LIMIT 2 [ RunTime:0.035575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14676638 ORDER BY `minOrder` ASC [ RunTime:0.014079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14677302 LIMIT 5 [ RunTime:0.089251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14677302 ORDER BY `minOrder` ASC [ RunTime:0.056172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14677302 ORDER BY `unit` DESC [ RunTime:0.056433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14677302 LIMIT 2 [ RunTime:0.049069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14677302 ORDER BY `minOrder` ASC [ RunTime:0.011576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11191579 LIMIT 5 [ RunTime:0.016414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11191579 ORDER BY `minOrder` ASC [ RunTime:0.018109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11191579 ORDER BY `unit` DESC [ RunTime:0.003857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11191579 LIMIT 2 [ RunTime:0.018303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11191579 ORDER BY `minOrder` ASC [ RunTime:0.033521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17491873 LIMIT 5 [ RunTime:0.090696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17491873 ORDER BY `minOrder` ASC [ RunTime:0.071374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17491873 ORDER BY `unit` DESC [ RunTime:0.080584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17491873 LIMIT 2 [ RunTime:0.082919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17491873 ORDER BY `minOrder` ASC [ RunTime:0.041639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17491241 LIMIT 5 [ RunTime:0.032215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17491241 ORDER BY `minOrder` ASC [ RunTime:0.037234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17491241 ORDER BY `unit` DESC [ RunTime:0.028948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17491241 LIMIT 2 [ RunTime:0.065088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17491241 ORDER BY `minOrder` ASC [ RunTime:0.047628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17484448 LIMIT 5 [ RunTime:0.048750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17484448 ORDER BY `minOrder` ASC [ RunTime:0.047016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17484448 ORDER BY `unit` DESC [ RunTime:0.043939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17484448 LIMIT 2 [ RunTime:0.079232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17484448 ORDER BY `minOrder` ASC [ RunTime:0.019999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14690088 LIMIT 5 [ RunTime:0.021379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14690088 ORDER BY `minOrder` ASC [ RunTime:0.025983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14690088 ORDER BY `unit` DESC [ RunTime:0.016316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14690088 LIMIT 2 [ RunTime:0.030333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14690088 ORDER BY `minOrder` ASC [ RunTime:0.004159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14686864 LIMIT 5 [ RunTime:0.030552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14686864 ORDER BY `minOrder` ASC [ RunTime:0.061775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14686864 ORDER BY `unit` DESC [ RunTime:0.051084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14686864 LIMIT 2 [ RunTime:0.050961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14686864 ORDER BY `minOrder` ASC [ RunTime:0.090484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14670939 LIMIT 5 [ RunTime:0.051476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14670939 ORDER BY `minOrder` ASC [ RunTime:0.050933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14670939 ORDER BY `unit` DESC [ RunTime:0.050935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14670939 LIMIT 2 [ RunTime:0.050901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14670939 ORDER BY `minOrder` ASC [ RunTime:0.050962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394442 LIMIT 5 [ RunTime:0.051751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394442 ORDER BY `minOrder` ASC [ RunTime:0.050994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394442 ORDER BY `unit` DESC [ RunTime:0.050922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394442 LIMIT 2 [ RunTime:0.050969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394442 ORDER BY `minOrder` ASC [ RunTime:0.050974s ]
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 '119215%' OR `brand` LIKE '119215%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134400 LIMIT 5 [ RunTime:0.050960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134400 ORDER BY `minOrder` ASC [ RunTime:0.051306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134400 ORDER BY `unit` DESC [ RunTime:0.050904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134400 LIMIT 2 [ RunTime:0.050913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134400 ORDER BY `minOrder` ASC [ RunTime:0.050950s ]
select * from pdf where partno='1192154' and brandshort='phoenix contact' limit 1 [ RunTime:0.038309s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1192154' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.025360s ]
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 '119215%' OR `brand` LIKE '119215%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.076203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55307095 LIMIT 5 [ RunTime:0.038037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55307095 ORDER BY `minOrder` ASC [ RunTime:0.026756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55307095 ORDER BY `unit` DESC [ RunTime:0.067029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55307095 LIMIT 2 [ RunTime:0.059253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55307095 ORDER BY `minOrder` ASC [ RunTime:0.027673s ]
select * from pdf where partno='1192152' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.039969s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1192152' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.100640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55309509 LIMIT 5 [ RunTime:0.066313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55309509 ORDER BY `minOrder` ASC [ RunTime:0.055884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55309509 ORDER BY `unit` DESC [ RunTime:0.037947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55309509 LIMIT 2 [ RunTime:0.014622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55309509 ORDER BY `minOrder` ASC [ RunTime:0.030849s ]
select * from pdf where partno='1192151' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.032781s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1192151' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.046459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55309489 LIMIT 5 [ RunTime:0.032875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55309489 ORDER BY `minOrder` ASC [ RunTime:0.042761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55309489 ORDER BY `unit` DESC [ RunTime:0.046354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55309489 LIMIT 2 [ RunTime:0.049843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55309489 ORDER BY `minOrder` ASC [ RunTime:0.030235s ]
select * from pdf where partno='1192154' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.072061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1192154' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.051355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55318678 LIMIT 5 [ RunTime:0.058427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55318678 ORDER BY `minOrder` ASC [ RunTime:0.028233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55318678 ORDER BY `unit` DESC [ RunTime:0.037353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55318678 LIMIT 2 [ RunTime:0.064397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55318678 ORDER BY `minOrder` ASC [ RunTime:0.008670s ]
select * from pdf where partno='1192155' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.025794s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1192155' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.078834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55311411 LIMIT 5 [ RunTime:0.027993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55311411 ORDER BY `minOrder` ASC [ RunTime:0.022864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55311411 ORDER BY `unit` DESC [ RunTime:0.028884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55311411 LIMIT 2 [ RunTime:0.042635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55311411 ORDER BY `minOrder` ASC [ RunTime:0.048401s ]
select * from pdf where partno='1192150' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.015686s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1192150' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.036428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57695421 LIMIT 5 [ RunTime:0.017237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695421 ORDER BY `minOrder` ASC [ RunTime:0.041821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57695421 ORDER BY `unit` DESC [ RunTime:0.032288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57695421 LIMIT 2 [ RunTime:0.044722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695421 ORDER BY `minOrder` ASC [ RunTime:0.018506s ]
select * from pdf where partno='119215' and brandshort='Brady Corporation' limit 1 [ RunTime:0.027353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '119215' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.063997s ]
SELECT `id` FROM `stock` WHERE `id` <> 57695421 AND `partno` = '119215' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.026169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394442 [ RunTime:0.007319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55368661 LIMIT 5 [ RunTime:0.026179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55368661 ORDER BY `minOrder` ASC [ RunTime:0.027579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55368661 ORDER BY `unit` DESC [ RunTime:0.034387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55368661 LIMIT 2 [ RunTime:0.023712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55368661 ORDER BY `minOrder` ASC [ RunTime:0.026069s ]
select * from pdf where partno='1192159' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.012839s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1192159' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55367083 LIMIT 5 [ RunTime:0.025761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55367083 ORDER BY `minOrder` ASC [ RunTime:0.021175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55367083 ORDER BY `unit` DESC [ RunTime:0.007942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55367083 LIMIT 2 [ RunTime:0.013103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55367083 ORDER BY `minOrder` ASC [ RunTime:0.006693s ]
select * from pdf where partno='1192156' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.011945s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1192156' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.015781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55359546 LIMIT 5 [ RunTime:0.020652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55359546 ORDER BY `minOrder` ASC [ RunTime:0.005431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55359546 ORDER BY `unit` DESC [ RunTime:0.007777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55359546 LIMIT 2 [ RunTime:0.016338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55359546 ORDER BY `minOrder` ASC [ RunTime:0.007203s ]
select * from pdf where partno='1192157' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.008097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1192157' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55346644 LIMIT 5 [ RunTime:0.007560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55346644 ORDER BY `minOrder` ASC [ RunTime:0.002902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55346644 ORDER BY `unit` DESC [ RunTime:0.018606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55346644 LIMIT 2 [ RunTime:0.010537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55346644 ORDER BY `minOrder` ASC [ RunTime:0.015058s ]
select * from pdf where partno='1192158' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.023223s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1192158' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.014769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51717069 LIMIT 5 [ RunTime:0.012801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51717069 ORDER BY `minOrder` ASC [ RunTime:0.006563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51717069 ORDER BY `unit` DESC [ RunTime:0.013639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51717069 LIMIT 2 [ RunTime:0.026472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51717069 ORDER BY `minOrder` ASC [ RunTime:0.016550s ]
select * from pdf where partno='1192151-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.012554s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1192151-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.020085s ]
SELECT `id` FROM `stock` WHERE `id` <> 51717069 AND `partno` = '1192151-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11191579 [ RunTime:0.007253s ]
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 '119215%' OR `brand` LIKE '119215%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019598s ]
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 '119215%' OR `brand` LIKE '119215%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010537s ]
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 '119215%' OR `brand` LIKE '119215%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011599s ]
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 '119215%' OR `brand` LIKE '119215%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014728s ]
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 '119215%' OR `brand` LIKE '119215%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014470s ]
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 '119215%' OR `brand` LIKE '119215%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010212s ]
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 '119215%' OR `brand` LIKE '119215%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010935s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '119215%' OR `brand` LIKE '119215%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007734s ]