SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002293s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.254' , `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=5242&search=1' [ RunTime:0.003306s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002280s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000534s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003236s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.254' ) [ RunTime:0.000479s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002275s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000415s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001921s ]
SELECT * FROM `stock_search` WHERE `partno` = '5242' LIMIT 1 [ RunTime:0.002953s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-04 14:16:14' WHERE `partno` = '5242' [ RunTime:0.007789s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001294s ]
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 '5242%' OR `brand` LIKE '5242%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016253s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19582782 LIMIT 5 [ RunTime:0.004988s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582782 ORDER BY `minOrder` ASC [ RunTime:0.003204s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19582782 ORDER BY `unit` DESC [ RunTime:0.002831s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19582782 LIMIT 2 [ RunTime:0.002189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582782 ORDER BY `minOrder` ASC [ RunTime:0.003399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14274693 LIMIT 5 [ RunTime:0.012352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14274693 ORDER BY `minOrder` ASC [ RunTime:0.009782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14274693 ORDER BY `unit` DESC [ RunTime:0.016997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14274693 LIMIT 2 [ RunTime:0.005302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14274693 ORDER BY `minOrder` ASC [ RunTime:0.017052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15441246 LIMIT 5 [ RunTime:0.012445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15441246 ORDER BY `minOrder` ASC [ RunTime:0.012877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15441246 ORDER BY `unit` DESC [ RunTime:0.021519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15441246 LIMIT 2 [ RunTime:0.001865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15441246 ORDER BY `minOrder` ASC [ RunTime:0.002923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19582917 LIMIT 5 [ RunTime:0.027415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582917 ORDER BY `minOrder` ASC [ RunTime:0.005514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19582917 ORDER BY `unit` DESC [ RunTime:0.009224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19582917 LIMIT 2 [ RunTime:0.002465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582917 ORDER BY `minOrder` ASC [ RunTime:0.005182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19581229 LIMIT 5 [ RunTime:0.003679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19581229 ORDER BY `minOrder` ASC [ RunTime:0.011802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19581229 ORDER BY `unit` DESC [ RunTime:0.009293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19581229 LIMIT 2 [ RunTime:0.006312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19581229 ORDER BY `minOrder` ASC [ RunTime:0.008767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19582720 LIMIT 5 [ RunTime:0.005047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582720 ORDER BY `minOrder` ASC [ RunTime:0.010709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19582720 ORDER BY `unit` DESC [ RunTime:0.009523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19582720 LIMIT 2 [ RunTime:0.010766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582720 ORDER BY `minOrder` ASC [ RunTime:0.008718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19582839 LIMIT 5 [ RunTime:0.007961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582839 ORDER BY `minOrder` ASC [ RunTime:0.015440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19582839 ORDER BY `unit` DESC [ RunTime:0.004405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19582839 LIMIT 2 [ RunTime:0.010195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582839 ORDER BY `minOrder` ASC [ RunTime:0.004042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19582952 LIMIT 5 [ RunTime:0.009429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582952 ORDER BY `minOrder` ASC [ RunTime:0.005196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19582952 ORDER BY `unit` DESC [ RunTime:0.018947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19582952 LIMIT 2 [ RunTime:0.007108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582952 ORDER BY `minOrder` ASC [ RunTime:0.006899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16422639 LIMIT 5 [ RunTime:0.008138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16422639 ORDER BY `minOrder` ASC [ RunTime:0.020914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16422639 ORDER BY `unit` DESC [ RunTime:0.015953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16422639 LIMIT 2 [ RunTime:0.009307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16422639 ORDER BY `minOrder` ASC [ RunTime:0.013826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19775478 LIMIT 5 [ RunTime:0.026829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19775478 ORDER BY `minOrder` ASC [ RunTime:0.007991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19775478 ORDER BY `unit` DESC [ RunTime:0.009382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19775478 LIMIT 2 [ RunTime:0.018302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19775478 ORDER BY `minOrder` ASC [ RunTime:0.008587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14408574 LIMIT 5 [ RunTime:0.006204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14408574 ORDER BY `minOrder` ASC [ RunTime:0.017784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14408574 ORDER BY `unit` DESC [ RunTime:0.018402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14408574 LIMIT 2 [ RunTime:0.031843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14408574 ORDER BY `minOrder` ASC [ RunTime:0.006637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16197611 LIMIT 5 [ RunTime:0.015886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197611 ORDER BY `minOrder` ASC [ RunTime:0.019353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16197611 ORDER BY `unit` DESC [ RunTime:0.020317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16197611 LIMIT 2 [ RunTime:0.012752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197611 ORDER BY `minOrder` ASC [ RunTime:0.012082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19775457 LIMIT 5 [ RunTime:0.035078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19775457 ORDER BY `minOrder` ASC [ RunTime:0.038646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19775457 ORDER BY `unit` DESC [ RunTime:0.016851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19775457 LIMIT 2 [ RunTime:0.029147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19775457 ORDER BY `minOrder` ASC [ RunTime:0.019323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19581228 LIMIT 5 [ RunTime:0.020084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19581228 ORDER BY `minOrder` ASC [ RunTime:0.017956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19581228 ORDER BY `unit` DESC [ RunTime:0.018861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19581228 LIMIT 2 [ RunTime:0.007561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19581228 ORDER BY `minOrder` ASC [ RunTime:0.002767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13538971 LIMIT 5 [ RunTime:0.002851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13538971 ORDER BY `minOrder` ASC [ RunTime:0.013152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13538971 ORDER BY `unit` DESC [ RunTime:0.010932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13538971 LIMIT 2 [ RunTime:0.011397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13538971 ORDER BY `minOrder` ASC [ RunTime:0.010997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13538968 LIMIT 5 [ RunTime:0.001627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13538968 ORDER BY `minOrder` ASC [ RunTime:0.001933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13538968 ORDER BY `unit` DESC [ RunTime:0.008176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13538968 LIMIT 2 [ RunTime:0.007250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13538968 ORDER BY `minOrder` ASC [ RunTime:0.002929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19775287 LIMIT 5 [ RunTime:0.015153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19775287 ORDER BY `minOrder` ASC [ RunTime:0.002304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19775287 ORDER BY `unit` DESC [ RunTime:0.011745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19775287 LIMIT 2 [ RunTime:0.006031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19775287 ORDER BY `minOrder` ASC [ RunTime:0.003697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13538223 LIMIT 5 [ RunTime:0.002254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13538223 ORDER BY `minOrder` ASC [ RunTime:0.001965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13538223 ORDER BY `unit` DESC [ RunTime:0.005324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13538223 LIMIT 2 [ RunTime:0.001158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13538223 ORDER BY `minOrder` ASC [ RunTime:0.001651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16423830 LIMIT 5 [ RunTime:0.003573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16423830 ORDER BY `minOrder` ASC [ RunTime:0.002063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16423830 ORDER BY `unit` DESC [ RunTime:0.001778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16423830 LIMIT 2 [ RunTime:0.002085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16423830 ORDER BY `minOrder` ASC [ RunTime:0.005031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19511280 LIMIT 5 [ RunTime:0.003529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19511280 ORDER BY `minOrder` ASC [ RunTime:0.008904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19511280 ORDER BY `unit` DESC [ RunTime:0.011754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19511280 LIMIT 2 [ RunTime:0.004363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19511280 ORDER BY `minOrder` ASC [ RunTime:0.002075s ]
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 '5242%' OR `brand` LIKE '5242%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281675 LIMIT 5 [ RunTime:0.007001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281675 ORDER BY `minOrder` ASC [ RunTime:0.007116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281675 ORDER BY `unit` DESC [ RunTime:0.001859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281675 LIMIT 2 [ RunTime:0.003417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281675 ORDER BY `minOrder` ASC [ RunTime:0.002766s ]
select * from pdf where partno='52420-3' and brandshort='te connectivity' limit 1 [ RunTime:0.011653s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52420-3' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.027762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281872 LIMIT 5 [ RunTime:0.011323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281872 ORDER BY `minOrder` ASC [ RunTime:0.021877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281872 ORDER BY `unit` DESC [ RunTime:0.011825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281872 LIMIT 2 [ RunTime:0.010288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281872 ORDER BY `minOrder` ASC [ RunTime:0.007145s ]
select * from pdf where partno='52420-2' and brandshort='te connectivity' limit 1 [ RunTime:0.008767s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52420-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.038834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281563 LIMIT 5 [ RunTime:0.010862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281563 ORDER BY `minOrder` ASC [ RunTime:0.010056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281563 ORDER BY `unit` DESC [ RunTime:0.013378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281563 LIMIT 2 [ RunTime:0.009714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281563 ORDER BY `minOrder` ASC [ RunTime:0.005935s ]
select * from pdf where partno='52420-2' and brandshort='te connectivity' limit 1 [ RunTime:0.000943s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52420-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.000961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281676 LIMIT 5 [ RunTime:0.007103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281676 ORDER BY `minOrder` ASC [ RunTime:0.000794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281676 ORDER BY `unit` DESC [ RunTime:0.002709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281676 LIMIT 2 [ RunTime:0.001265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281676 ORDER BY `minOrder` ASC [ RunTime:0.004379s ]
select * from pdf where partno='52420-1' and brandshort='te connectivity' limit 1 [ RunTime:0.003515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52420-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.015468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282221 LIMIT 5 [ RunTime:0.008396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282221 ORDER BY `minOrder` ASC [ RunTime:0.012085s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282221 ORDER BY `unit` DESC [ RunTime:0.003468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282221 LIMIT 2 [ RunTime:0.015963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282221 ORDER BY `minOrder` ASC [ RunTime:0.000512s ]
select * from pdf where partno='52423' and brandshort='te connectivity' limit 1 [ RunTime:0.005740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52423' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.027486s ]
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 '5242%' OR `brand` LIKE '5242%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60637087 LIMIT 5 [ RunTime:0.003435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637087 ORDER BY `minOrder` ASC [ RunTime:0.006073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60637087 ORDER BY `unit` DESC [ RunTime:0.000518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60637087 LIMIT 2 [ RunTime:0.000980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637087 ORDER BY `minOrder` ASC [ RunTime:0.002706s ]
select * from pdf where partno='52420-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003725s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52420-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009465s ]
SELECT `id` FROM `stock` WHERE `id` <> 60637087 AND `partno` = '52420-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19581228 [ RunTime:0.006611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60636892 LIMIT 5 [ RunTime:0.010739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60636892 ORDER BY `minOrder` ASC [ RunTime:0.011326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60636892 ORDER BY `unit` DESC [ RunTime:0.003135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60636892 LIMIT 2 [ RunTime:0.002895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60636892 ORDER BY `minOrder` ASC [ RunTime:0.011055s ]
select * from pdf where partno='52421-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.011159s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52421-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.011706s ]
SELECT `id` FROM `stock` WHERE `id` <> 60636892 AND `partno` = '52421-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.004405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19581229 [ RunTime:0.010105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60637098 LIMIT 5 [ RunTime:0.016376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637098 ORDER BY `minOrder` ASC [ RunTime:0.002069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60637098 ORDER BY `unit` DESC [ RunTime:0.018518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60637098 LIMIT 2 [ RunTime:0.018107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637098 ORDER BY `minOrder` ASC [ RunTime:0.003059s ]
select * from pdf where partno='52421-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000596s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52421-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007712s ]
SELECT `id` FROM `stock` WHERE `id` <> 60637098 AND `partno` = '52421-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.015536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15441246 [ RunTime:0.002381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58104576 LIMIT 5 [ RunTime:0.005457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104576 ORDER BY `minOrder` ASC [ RunTime:0.016487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58104576 ORDER BY `unit` DESC [ RunTime:0.015082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58104576 LIMIT 2 [ RunTime:0.003828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104576 ORDER BY `minOrder` ASC [ RunTime:0.001935s ]
select * from pdf where partno='5242' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.007319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5242' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.025175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60637106 LIMIT 5 [ RunTime:0.011200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637106 ORDER BY `minOrder` ASC [ RunTime:0.006493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60637106 ORDER BY `unit` DESC [ RunTime:0.002206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60637106 LIMIT 2 [ RunTime:0.000751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637106 ORDER BY `minOrder` ASC [ RunTime:0.000677s ]
select * from pdf where partno='52422-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.010768s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52422-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001625s ]
SELECT `id` FROM `stock` WHERE `id` <> 60637106 AND `partno` = '52422-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19582917 [ RunTime:0.004938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60637092 LIMIT 5 [ RunTime:0.000771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637092 ORDER BY `minOrder` ASC [ RunTime:0.011709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60637092 ORDER BY `unit` DESC [ RunTime:0.000871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60637092 LIMIT 2 [ RunTime:0.002136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637092 ORDER BY `minOrder` ASC [ RunTime:0.003360s ]
select * from pdf where partno='52422-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52422-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006538s ]
SELECT `id` FROM `stock` WHERE `id` <> 60637092 AND `partno` = '52422-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.010518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19582720 [ RunTime:0.004037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59445112 LIMIT 5 [ RunTime:0.000850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59445112 ORDER BY `minOrder` ASC [ RunTime:0.023206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59445112 ORDER BY `unit` DESC [ RunTime:0.005595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59445112 LIMIT 2 [ RunTime:0.003814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59445112 ORDER BY `minOrder` ASC [ RunTime:0.001449s ]
select * from pdf where partno='524227-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.003123s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '524227-E' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.000701s ]
SELECT `id` FROM `stock` WHERE `id` <> 59445112 AND `partno` = '524227-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.003829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16197611 [ RunTime:0.000563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59446163 LIMIT 5 [ RunTime:0.000816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59446163 ORDER BY `minOrder` ASC [ RunTime:0.010925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59446163 ORDER BY `unit` DESC [ RunTime:0.005476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59446163 LIMIT 2 [ RunTime:0.003796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59446163 ORDER BY `minOrder` ASC [ RunTime:0.005761s ]
select * from pdf where partno='524226-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.010264s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '524226-E' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.016328s ]
SELECT `id` FROM `stock` WHERE `id` <> 59446163 AND `partno` = '524226-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.003704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19775287 [ RunTime:0.004657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59452487 LIMIT 5 [ RunTime:0.009522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59452487 ORDER BY `minOrder` ASC [ RunTime:0.012887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59452487 ORDER BY `unit` DESC [ RunTime:0.012025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59452487 LIMIT 2 [ RunTime:0.010212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59452487 ORDER BY `minOrder` ASC [ RunTime:0.002107s ]
select * from pdf where partno='524236-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.003457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '524236-E' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.013117s ]
SELECT `id` FROM `stock` WHERE `id` <> 59452487 AND `partno` = '524236-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.014623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63126477 LIMIT 5 [ RunTime:0.011383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126477 ORDER BY `minOrder` ASC [ RunTime:0.021327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63126477 ORDER BY `unit` DESC [ RunTime:0.006108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63126477 LIMIT 2 [ RunTime:0.010511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126477 ORDER BY `minOrder` ASC [ RunTime:0.002440s ]
select * from pdf where partno='524216000' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.026203s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '524216000' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.047571s ]
SELECT `id` FROM `stock` WHERE `id` <> 63126477 AND `partno` = '524216000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.031822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13538223 [ RunTime:0.041500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63126104 LIMIT 5 [ RunTime:0.026341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126104 ORDER BY `minOrder` ASC [ RunTime:0.032352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63126104 ORDER BY `unit` DESC [ RunTime:0.008165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63126104 LIMIT 2 [ RunTime:0.011390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126104 ORDER BY `minOrder` ASC [ RunTime:0.007270s ]
select * from pdf where partno='524212000' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.007808s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '524212000' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.027881s ]
SELECT `id` FROM `stock` WHERE `id` <> 63126104 AND `partno` = '524212000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.012687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16422639 [ RunTime:0.003676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60637496 LIMIT 5 [ RunTime:0.015057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637496 ORDER BY `minOrder` ASC [ RunTime:0.024916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60637496 ORDER BY `unit` DESC [ RunTime:0.019527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60637496 LIMIT 2 [ RunTime:0.003979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637496 ORDER BY `minOrder` ASC [ RunTime:0.001327s ]
select * from pdf where partno='52420-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006724s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52420-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.012561s ]
SELECT `id` FROM `stock` WHERE `id` <> 60637496 AND `partno` = '52420-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19582782 [ RunTime:0.006617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60637170 LIMIT 5 [ RunTime:0.010924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637170 ORDER BY `minOrder` ASC [ RunTime:0.018023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60637170 ORDER BY `unit` DESC [ RunTime:0.004099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60637170 LIMIT 2 [ RunTime:0.004776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637170 ORDER BY `minOrder` ASC [ RunTime:0.003233s ]
select * from pdf where partno='52420-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.009286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52420-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004065s ]
SELECT `id` FROM `stock` WHERE `id` <> 60637170 AND `partno` = '52420-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19582952 [ RunTime:0.007050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59446867 LIMIT 5 [ RunTime:0.008670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59446867 ORDER BY `minOrder` ASC [ RunTime:0.016615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59446867 ORDER BY `unit` DESC [ RunTime:0.002885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59446867 LIMIT 2 [ RunTime:0.056291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59446867 ORDER BY `minOrder` ASC [ RunTime:0.013106s ]
select * from pdf where partno='524233-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.018376s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '524233-E' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.034790s ]
SELECT `id` FROM `stock` WHERE `id` <> 59446867 AND `partno` = '524233-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.023644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19775478 [ RunTime:0.010510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63127496 LIMIT 5 [ RunTime:0.019401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63127496 ORDER BY `minOrder` ASC [ RunTime:0.016704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63127496 ORDER BY `unit` DESC [ RunTime:0.008828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63127496 LIMIT 2 [ RunTime:0.045794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63127496 ORDER BY `minOrder` ASC [ RunTime:0.011132s ]
select * from pdf where partno='524214000' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.025631s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '524214000' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.030131s ]
SELECT `id` FROM `stock` WHERE `id` <> 63127496 AND `partno` = '524214000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.016603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14408574 [ RunTime:0.014235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59450408 LIMIT 5 [ RunTime:0.004505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59450408 ORDER BY `minOrder` ASC [ RunTime:0.015490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59450408 ORDER BY `unit` DESC [ RunTime:0.013866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59450408 LIMIT 2 [ RunTime:0.015292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59450408 ORDER BY `minOrder` ASC [ RunTime:0.002208s ]
select * from pdf where partno='524232-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.007904s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '524232-E' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.014335s ]
SELECT `id` FROM `stock` WHERE `id` <> 59450408 AND `partno` = '524232-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.031688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19775457 [ RunTime:0.034745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57237349 LIMIT 5 [ RunTime:0.013740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57237349 ORDER BY `minOrder` ASC [ RunTime:0.020067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57237349 ORDER BY `unit` DESC [ RunTime:0.017468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57237349 LIMIT 2 [ RunTime:0.008569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57237349 ORDER BY `minOrder` ASC [ RunTime:0.011582s ]
select * from pdf where partno='5242' and brandshort='Pololu' limit 1 [ RunTime:0.022095s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5242' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.020058s ]
SELECT `id` FROM `stock` WHERE `id` <> 57237349 AND `partno` = '5242' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.025368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19511280 [ RunTime:0.002498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63127642 LIMIT 5 [ RunTime:0.007833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63127642 ORDER BY `minOrder` ASC [ RunTime:0.037486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63127642 ORDER BY `unit` DESC [ RunTime:0.006056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63127642 LIMIT 2 [ RunTime:0.006869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63127642 ORDER BY `minOrder` ASC [ RunTime:0.005797s ]
select * from pdf where partno='524258000' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.007537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '524258000' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.003098s ]
SELECT `id` FROM `stock` WHERE `id` <> 63127642 AND `partno` = '524258000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.028179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16422766 [ RunTime:0.007601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63127632 LIMIT 5 [ RunTime:0.001864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63127632 ORDER BY `minOrder` ASC [ RunTime:0.008182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63127632 ORDER BY `unit` DESC [ RunTime:0.003450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63127632 LIMIT 2 [ RunTime:0.011260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63127632 ORDER BY `minOrder` ASC [ RunTime:0.002309s ]
select * from pdf where partno='524256000' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001199s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '524256000' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001050s ]
SELECT `id` FROM `stock` WHERE `id` <> 63127632 AND `partno` = '524256000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16422991 [ RunTime:0.000959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58412832 LIMIT 5 [ RunTime:0.005844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58412832 ORDER BY `minOrder` ASC [ RunTime:0.011650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58412832 ORDER BY `unit` DESC [ RunTime:0.018689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58412832 LIMIT 2 [ RunTime:0.036355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58412832 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
select * from pdf where partno='5242MIWRCDB' and brandshort='APEM Inc.' limit 1 [ RunTime:0.002293s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5242MIWRCDB' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.002544s ]
SELECT `id` FROM `stock` WHERE `id` <> 58412832 AND `partno` = '5242MIWRCDB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.006017s ]
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 '5242%' OR `brand` LIKE '5242%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011256s ]
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 '5242%' OR `brand` LIKE '5242%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001465s ]
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 '5242%' OR `brand` LIKE '5242%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003752s ]
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 '5242%' OR `brand` LIKE '5242%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006440s ]
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 '5242%' OR `brand` LIKE '5242%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023399s ]
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 '5242%' OR `brand` LIKE '5242%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012792s ]
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 '5242%' OR `brand` LIKE '5242%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013087s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5242%' OR `brand` LIKE '5242%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003666s ]