SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001483s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.101' , `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=15430&search=1' [ RunTime:0.002843s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003001s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002415s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002037s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.101' ) [ RunTime:0.000451s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001168s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000390s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001100s ]
SELECT * FROM `stock_search` WHERE `partno` = '15430' LIMIT 1 [ RunTime:0.000684s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-10-09 18:08:58' WHERE `partno` = '15430' [ RunTime:0.001664s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001521s ]
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 '15430%' OR `brand` LIKE '15430%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004279s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10899137 LIMIT 5 [ RunTime:0.000793s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10899137 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10899137 ORDER BY `unit` DESC [ RunTime:0.000351s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10899137 LIMIT 2 [ RunTime:0.000404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10899137 ORDER BY `minOrder` ASC [ RunTime:0.000405s ]
select * from pdf where partno='1543045' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10988541 LIMIT 5 [ RunTime:0.001078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10988541 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10988541 ORDER BY `unit` DESC [ RunTime:0.000342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10988541 LIMIT 2 [ RunTime:0.000324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10988541 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16623979 LIMIT 5 [ RunTime:0.000693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16623979 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16623979 ORDER BY `unit` DESC [ RunTime:0.000366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16623979 LIMIT 2 [ RunTime:0.000309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16623979 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650341 LIMIT 5 [ RunTime:0.000751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650341 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19650341 ORDER BY `unit` DESC [ RunTime:0.000319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19650341 LIMIT 2 [ RunTime:0.000332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650341 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650340 LIMIT 5 [ RunTime:0.000331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650340 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19650340 ORDER BY `unit` DESC [ RunTime:0.000302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19650340 LIMIT 2 [ RunTime:0.000291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650340 ORDER BY `minOrder` ASC [ RunTime:0.000328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19647354 LIMIT 5 [ RunTime:0.000690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19647354 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19647354 ORDER BY `unit` DESC [ RunTime:0.000330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19647354 LIMIT 2 [ RunTime:0.000305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19647354 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19647352 LIMIT 5 [ RunTime:0.000327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19647352 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19647352 ORDER BY `unit` DESC [ RunTime:0.000315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19647352 LIMIT 2 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19647352 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19646740 LIMIT 5 [ RunTime:0.000699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19646740 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19646740 ORDER BY `unit` DESC [ RunTime:0.000375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19646740 LIMIT 2 [ RunTime:0.000386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19646740 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19644128 LIMIT 5 [ RunTime:0.000620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19644128 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19644128 ORDER BY `unit` DESC [ RunTime:0.000301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19644128 LIMIT 2 [ RunTime:0.000316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19644128 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17311019 LIMIT 5 [ RunTime:0.001057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17311019 ORDER BY `minOrder` ASC [ RunTime:0.000634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17311019 ORDER BY `unit` DESC [ RunTime:0.000531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17311019 LIMIT 2 [ RunTime:0.000523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17311019 ORDER BY `minOrder` ASC [ RunTime:0.000518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15451713 LIMIT 5 [ RunTime:0.001183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15451713 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15451713 ORDER BY `unit` DESC [ RunTime:0.000410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15451713 LIMIT 2 [ RunTime:0.000459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15451713 ORDER BY `minOrder` ASC [ RunTime:0.000500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15451712 LIMIT 5 [ RunTime:0.000504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15451712 ORDER BY `minOrder` ASC [ RunTime:0.000505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15451712 ORDER BY `unit` DESC [ RunTime:0.000407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15451712 LIMIT 2 [ RunTime:0.000389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15451712 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12394837 LIMIT 5 [ RunTime:0.000695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12394837 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12394837 ORDER BY `unit` DESC [ RunTime:0.000402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12394837 LIMIT 2 [ RunTime:0.000394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12394837 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
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 '15430%' OR `brand` LIKE '15430%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001288s ]
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 '15430%' OR `brand` LIKE '15430%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69774772 LIMIT 5 [ RunTime:0.000472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69774772 ORDER BY `minOrder` ASC [ RunTime:0.000777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69774772 ORDER BY `unit` DESC [ RunTime:0.000250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69774772 LIMIT 2 [ RunTime:0.000231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69774772 ORDER BY `minOrder` ASC [ RunTime:0.000260s ]
select * from pdf where partno='154302-01' and brandshort='NI' limit 1 [ RunTime:0.000575s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '154302-01' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.001660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34465536 LIMIT 5 [ RunTime:0.000304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34465536 ORDER BY `minOrder` ASC [ RunTime:0.000607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34465536 ORDER BY `unit` DESC [ RunTime:0.000253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34465536 LIMIT 2 [ RunTime:0.000236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34465536 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
select * from pdf where partno='1543032' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1543032' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67977814 LIMIT 5 [ RunTime:0.000270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67977814 ORDER BY `minOrder` ASC [ RunTime:0.002031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67977814 ORDER BY `unit` DESC [ RunTime:0.000298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67977814 LIMIT 2 [ RunTime:0.000281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67977814 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
select * from pdf where partno='1543061' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001434s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1543061' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70835367 LIMIT 5 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70835367 ORDER BY `minOrder` ASC [ RunTime:0.000867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70835367 ORDER BY `unit` DESC [ RunTime:0.000534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70835367 LIMIT 2 [ RunTime:0.000414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70835367 ORDER BY `minOrder` ASC [ RunTime:0.000374s ]
select * from pdf where partno='15430' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.000948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15430' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.000825s ]
SELECT `id` FROM `stock` WHERE `id` <> 70835367 AND `partno` = '15430' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.000513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12394837 [ RunTime:0.000386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69922610 LIMIT 5 [ RunTime:0.000420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69922610 ORDER BY `minOrder` ASC [ RunTime:0.000815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69922610 ORDER BY `unit` DESC [ RunTime:0.000435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69922610 LIMIT 2 [ RunTime:0.000415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69922610 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
select * from pdf where partno='15430' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.000877s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15430' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.000682s ]
SELECT `id` FROM `stock` WHERE `id` <> 69922610 AND `partno` = '15430' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.000535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67974548 LIMIT 5 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67974548 ORDER BY `minOrder` ASC [ RunTime:0.000699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67974548 ORDER BY `unit` DESC [ RunTime:0.000424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67974548 LIMIT 2 [ RunTime:0.000405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67974548 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
select * from pdf where partno='1543045' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1543045' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67357642 LIMIT 5 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67357642 ORDER BY `minOrder` ASC [ RunTime:0.000694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67357642 ORDER BY `unit` DESC [ RunTime:0.000402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67357642 LIMIT 2 [ RunTime:0.000387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67357642 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
select * from pdf where partno='1543080000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1543080000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000794s ]
SELECT `id` FROM `stock` WHERE `id` <> 67357642 AND `partno` = '1543080000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17311019 [ RunTime:0.000391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67355541 LIMIT 5 [ RunTime:0.000401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67355541 ORDER BY `minOrder` ASC [ RunTime:0.000776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67355541 ORDER BY `unit` DESC [ RunTime:0.000397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67355541 LIMIT 2 [ RunTime:0.000381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67355541 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
select * from pdf where partno='1543030000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1543030000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000785s ]
SELECT `id` FROM `stock` WHERE `id` <> 67355541 AND `partno` = '1543030000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15451713 [ RunTime:0.000446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67355540 LIMIT 5 [ RunTime:0.000391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67355540 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67355540 ORDER BY `unit` DESC [ RunTime:0.000401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67355540 LIMIT 2 [ RunTime:0.000377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67355540 ORDER BY `minOrder` ASC [ RunTime:0.000407s ]
select * from pdf where partno='1543050000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1543050000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000777s ]
SELECT `id` FROM `stock` WHERE `id` <> 67355540 AND `partno` = '1543050000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15451712 [ RunTime:0.000431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67355539 LIMIT 5 [ RunTime:0.000417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67355539 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67355539 ORDER BY `unit` DESC [ RunTime:0.000400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67355539 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67355539 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
select * from pdf where partno='1543060000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000884s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1543060000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000789s ]
SELECT `id` FROM `stock` WHERE `id` <> 67355539 AND `partno` = '1543060000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650341 [ RunTime:0.000455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67355538 LIMIT 5 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67355538 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67355538 ORDER BY `unit` DESC [ RunTime:0.000396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67355538 LIMIT 2 [ RunTime:0.000383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67355538 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
select * from pdf where partno='1543040000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000855s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1543040000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000758s ]
SELECT `id` FROM `stock` WHERE `id` <> 67355538 AND `partno` = '1543040000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650340 [ RunTime:0.000466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67351533 LIMIT 5 [ RunTime:0.000433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67351533 ORDER BY `minOrder` ASC [ RunTime:0.000765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67351533 ORDER BY `unit` DESC [ RunTime:0.000338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67351533 LIMIT 2 [ RunTime:0.000324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67351533 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
select * from pdf where partno='1543010000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000993s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1543010000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000729s ]
SELECT `id` FROM `stock` WHERE `id` <> 67351533 AND `partno` = '1543010000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19647354 [ RunTime:0.000405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67351531 LIMIT 5 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67351531 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67351531 ORDER BY `unit` DESC [ RunTime:0.000373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67351531 LIMIT 2 [ RunTime:0.000316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67351531 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
select * from pdf where partno='1543020000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001031s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1543020000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000753s ]
SELECT `id` FROM `stock` WHERE `id` <> 67351531 AND `partno` = '1543020000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19647352 [ RunTime:0.000387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67350803 LIMIT 5 [ RunTime:0.000428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67350803 ORDER BY `minOrder` ASC [ RunTime:0.000646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67350803 ORDER BY `unit` DESC [ RunTime:0.000336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67350803 LIMIT 2 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67350803 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
select * from pdf where partno='1543090000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1543090000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000785s ]
SELECT `id` FROM `stock` WHERE `id` <> 67350803 AND `partno` = '1543090000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19646740 [ RunTime:0.000378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67347392 LIMIT 5 [ RunTime:0.000426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67347392 ORDER BY `minOrder` ASC [ RunTime:0.000765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67347392 ORDER BY `unit` DESC [ RunTime:0.000339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67347392 LIMIT 2 [ RunTime:0.000323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67347392 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
select * from pdf where partno='1543070000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000996s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1543070000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000764s ]
SELECT `id` FROM `stock` WHERE `id` <> 67347392 AND `partno` = '1543070000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19644128 [ RunTime:0.000529s ]
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 '15430%' OR `brand` LIKE '15430%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000713s ]
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 '15430%' OR `brand` LIKE '15430%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000599s ]
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 '15430%' OR `brand` LIKE '15430%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000586s ]
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 '15430%' OR `brand` LIKE '15430%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000706s ]
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 '15430%' OR `brand` LIKE '15430%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000588s ]
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 '15430%' OR `brand` LIKE '15430%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000622s ]
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 '15430%' OR `brand` LIKE '15430%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000735s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '15430%' OR `brand` LIKE '15430%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000711s ]