SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001883s ]
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=FTSH-105-01-S-D&search=1' [ RunTime:0.012372s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002547s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.008941s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002966s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.009955s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002127s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.025259s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002165s ]
SELECT * FROM `stock_search` WHERE `partno` = 'FTSH-105-01-S-D' LIMIT 1 [ RunTime:0.045255s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-08-26 03:43:23' WHERE `partno` = 'FTSH-105-01-S-D' [ RunTime:0.011507s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002415s ]
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 'FTSH-105-01-S-D%' OR `brand` LIKE 'FTSH-105-01-S-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.066304s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.014964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19831987 LIMIT 5 [ RunTime:0.050801s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19831987 ORDER BY `minOrder` ASC [ RunTime:0.019087s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19831987 ORDER BY `unit` DESC [ RunTime:0.022968s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19831987 LIMIT 2 [ RunTime:0.037686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19831987 ORDER BY `minOrder` ASC [ RunTime:0.009644s ]
select * from pdf where partno='FTSH-105-01-S-DV-K-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.064537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19851623 LIMIT 5 [ RunTime:0.044370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19851623 ORDER BY `minOrder` ASC [ RunTime:0.054454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19851623 ORDER BY `unit` DESC [ RunTime:0.075106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19851623 LIMIT 2 [ RunTime:0.045113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19851623 ORDER BY `minOrder` ASC [ RunTime:0.050010s ]
select * from pdf where partno='FTSH-105-01-S-DV-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.031585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19775267 LIMIT 5 [ RunTime:0.035186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19775267 ORDER BY `minOrder` ASC [ RunTime:0.014433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19775267 ORDER BY `unit` DESC [ RunTime:0.020093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19775267 LIMIT 2 [ RunTime:0.020356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19775267 ORDER BY `minOrder` ASC [ RunTime:0.003245s ]
select * from pdf where partno='FTSH-105-01-S-DV-K-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.020879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19846165 LIMIT 5 [ RunTime:0.004714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19846165 ORDER BY `minOrder` ASC [ RunTime:0.019615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19846165 ORDER BY `unit` DESC [ RunTime:0.002718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19846165 LIMIT 2 [ RunTime:0.003380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19846165 ORDER BY `minOrder` ASC [ RunTime:0.001929s ]
select * from pdf where partno='FTSH-105-01-S-DV-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19833229 LIMIT 5 [ RunTime:0.016764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833229 ORDER BY `minOrder` ASC [ RunTime:0.005198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19833229 ORDER BY `unit` DESC [ RunTime:0.004771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19833229 LIMIT 2 [ RunTime:0.008661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833229 ORDER BY `minOrder` ASC [ RunTime:0.035687s ]
select * from pdf where partno='FTSH-105-01-S-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19833321 LIMIT 5 [ RunTime:0.018381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833321 ORDER BY `minOrder` ASC [ RunTime:0.015215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19833321 ORDER BY `unit` DESC [ RunTime:0.035616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19833321 LIMIT 2 [ RunTime:0.011174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833321 ORDER BY `minOrder` ASC [ RunTime:0.000729s ]
select * from pdf where partno='FTSH-105-01-S-D-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19833041 LIMIT 5 [ RunTime:0.032484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833041 ORDER BY `minOrder` ASC [ RunTime:0.051843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19833041 ORDER BY `unit` DESC [ RunTime:0.029168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19833041 LIMIT 2 [ RunTime:0.020163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833041 ORDER BY `minOrder` ASC [ RunTime:0.006903s ]
select * from pdf where partno='FTSH-105-01-S-DV-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.028119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19797664 LIMIT 5 [ RunTime:0.039581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19797664 ORDER BY `minOrder` ASC [ RunTime:0.031731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19797664 ORDER BY `unit` DESC [ RunTime:0.072104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19797664 LIMIT 2 [ RunTime:0.023715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19797664 ORDER BY `minOrder` ASC [ RunTime:0.011968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19794454 LIMIT 5 [ RunTime:0.021662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19794454 ORDER BY `minOrder` ASC [ RunTime:0.012697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19794454 ORDER BY `unit` DESC [ RunTime:0.012507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19794454 LIMIT 2 [ RunTime:0.008274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19794454 ORDER BY `minOrder` ASC [ RunTime:0.002486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19793869 LIMIT 5 [ RunTime:0.015431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19793869 ORDER BY `minOrder` ASC [ RunTime:0.035592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19793869 ORDER BY `unit` DESC [ RunTime:0.024381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19793869 LIMIT 2 [ RunTime:0.016627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19793869 ORDER BY `minOrder` ASC [ RunTime:0.010707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19792723 LIMIT 5 [ RunTime:0.053151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19792723 ORDER BY `minOrder` ASC [ RunTime:0.001821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19792723 ORDER BY `unit` DESC [ RunTime:0.038243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19792723 LIMIT 2 [ RunTime:0.022691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19792723 ORDER BY `minOrder` ASC [ RunTime:0.019627s ]
select * from pdf where partno='FTSH-105-01-S-DV-K-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.018724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19787999 LIMIT 5 [ RunTime:0.024064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19787999 ORDER BY `minOrder` ASC [ RunTime:0.026020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19787999 ORDER BY `unit` DESC [ RunTime:0.042536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19787999 LIMIT 2 [ RunTime:0.032497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19787999 ORDER BY `minOrder` ASC [ RunTime:0.040528s ]
select * from pdf where partno='FTSH-105-01-S-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19786243 LIMIT 5 [ RunTime:0.030062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19786243 ORDER BY `minOrder` ASC [ RunTime:0.032888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19786243 ORDER BY `unit` DESC [ RunTime:0.046136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19786243 LIMIT 2 [ RunTime:0.024007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19786243 ORDER BY `minOrder` ASC [ RunTime:0.015875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19786086 LIMIT 5 [ RunTime:0.023607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19786086 ORDER BY `minOrder` ASC [ RunTime:0.011267s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19786086 ORDER BY `unit` DESC [ RunTime:0.025983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19786086 LIMIT 2 [ RunTime:0.019438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19786086 ORDER BY `minOrder` ASC [ RunTime:0.002422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19785180 LIMIT 5 [ RunTime:0.035389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19785180 ORDER BY `minOrder` ASC [ RunTime:0.005603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19785180 ORDER BY `unit` DESC [ RunTime:0.051928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19785180 LIMIT 2 [ RunTime:0.008827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19785180 ORDER BY `minOrder` ASC [ RunTime:0.016439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19781713 LIMIT 5 [ RunTime:0.049011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19781713 ORDER BY `minOrder` ASC [ RunTime:0.036059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19781713 ORDER BY `unit` DESC [ RunTime:0.038090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19781713 LIMIT 2 [ RunTime:0.035130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19781713 ORDER BY `minOrder` ASC [ RunTime:0.006170s ]
select * from pdf where partno='FTSH-105-01-S-D-RA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.023695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16227210 LIMIT 5 [ RunTime:0.006838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16227210 ORDER BY `minOrder` ASC [ RunTime:0.029838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16227210 ORDER BY `unit` DESC [ RunTime:0.011581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16227210 LIMIT 2 [ RunTime:0.034617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16227210 ORDER BY `minOrder` ASC [ RunTime:0.027579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16226969 LIMIT 5 [ RunTime:0.017408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16226969 ORDER BY `minOrder` ASC [ RunTime:0.001668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16226969 ORDER BY `unit` DESC [ RunTime:0.005625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16226969 LIMIT 2 [ RunTime:0.058297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16226969 ORDER BY `minOrder` ASC [ RunTime:0.011849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16210574 LIMIT 5 [ RunTime:0.023261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16210574 ORDER BY `minOrder` ASC [ RunTime:0.009164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16210574 ORDER BY `unit` DESC [ RunTime:0.032130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16210574 LIMIT 2 [ RunTime:0.011035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16210574 ORDER BY `minOrder` ASC [ RunTime:0.003268s ]
select * from pdf where partno='FTSH-105-01-S-DV-007-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.025451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16207611 LIMIT 5 [ RunTime:0.014316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16207611 ORDER BY `minOrder` ASC [ RunTime:0.046364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16207611 ORDER BY `unit` DESC [ RunTime:0.056878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16207611 LIMIT 2 [ RunTime:0.072784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16207611 ORDER BY `minOrder` ASC [ RunTime:0.007597s ]
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 'FTSH-105-01-S-D%' OR `brand` LIKE 'FTSH-105-01-S-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039190s ]
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 'FTSH-105-01-S-D%' OR `brand` LIKE 'FTSH-105-01-S-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59439500 LIMIT 5 [ RunTime:0.027981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59439500 ORDER BY `minOrder` ASC [ RunTime:0.076777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59439500 ORDER BY `unit` DESC [ RunTime:0.025498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59439500 LIMIT 2 [ RunTime:0.014265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59439500 ORDER BY `minOrder` ASC [ RunTime:0.018648s ]
select * from pdf where partno='FTSH-105-01-S-DV-K-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014751s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002729s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-S-DV-K-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.019587s ]
SELECT `id` FROM `stock` WHERE `id` <> 59439500 AND `partno` = 'FTSH-105-01-S-DV-K-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.053243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19831987 [ RunTime:0.007526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59445042 LIMIT 5 [ RunTime:0.020186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59445042 ORDER BY `minOrder` ASC [ RunTime:0.048137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59445042 ORDER BY `unit` DESC [ RunTime:0.085494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59445042 LIMIT 2 [ RunTime:0.122100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59445042 ORDER BY `minOrder` ASC [ RunTime:0.048472s ]
select * from pdf where partno='FTSH-105-01-S-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008503s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-S-DV' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.103031s ]
SELECT `id` FROM `stock` WHERE `id` <> 59445042 AND `partno` = 'FTSH-105-01-S-DV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.071468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19833229 [ RunTime:0.101165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59440401 LIMIT 5 [ RunTime:0.033704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59440401 ORDER BY `minOrder` ASC [ RunTime:0.120496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59440401 ORDER BY `unit` DESC [ RunTime:0.098919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59440401 LIMIT 2 [ RunTime:0.037268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59440401 ORDER BY `minOrder` ASC [ RunTime:0.032288s ]
select * from pdf where partno='FTSH-105-01-S-DV-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.030108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-S-DV-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.048521s ]
SELECT `id` FROM `stock` WHERE `id` <> 59440401 AND `partno` = 'FTSH-105-01-S-DV-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.057012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19846165 [ RunTime:0.048871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59449988 LIMIT 5 [ RunTime:0.050349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59449988 ORDER BY `minOrder` ASC [ RunTime:0.046429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59449988 ORDER BY `unit` DESC [ RunTime:0.038349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59449988 LIMIT 2 [ RunTime:0.013765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59449988 ORDER BY `minOrder` ASC [ RunTime:0.014386s ]
select * from pdf where partno='FTSH-105-01-S-DV-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011067s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-S-DV-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.033058s ]
SELECT `id` FROM `stock` WHERE `id` <> 59449988 AND `partno` = 'FTSH-105-01-S-DV-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.057783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19851623 [ RunTime:0.023875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59449765 LIMIT 5 [ RunTime:0.012830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59449765 ORDER BY `minOrder` ASC [ RunTime:0.008332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59449765 ORDER BY `unit` DESC [ RunTime:0.015068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59449765 LIMIT 2 [ RunTime:0.016766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59449765 ORDER BY `minOrder` ASC [ RunTime:0.012545s ]
select * from pdf where partno='FTSH-105-01-S-DV-K-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-S-DV-K-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002796s ]
SELECT `id` FROM `stock` WHERE `id` <> 59449765 AND `partno` = 'FTSH-105-01-S-DV-K-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19775267 [ RunTime:0.013515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59679639 LIMIT 5 [ RunTime:0.011286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59679639 ORDER BY `minOrder` ASC [ RunTime:0.025021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59679639 ORDER BY `unit` DESC [ RunTime:0.009897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59679639 LIMIT 2 [ RunTime:0.002816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59679639 ORDER BY `minOrder` ASC [ RunTime:0.000941s ]
select * from pdf where partno='FTSH-105-01-S-DH-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.023112s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-S-DH-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.016750s ]
SELECT `id` FROM `stock` WHERE `id` <> 59679639 AND `partno` = 'FTSH-105-01-S-DH-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.026100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59671235 LIMIT 5 [ RunTime:0.009526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59671235 ORDER BY `minOrder` ASC [ RunTime:0.022099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59671235 ORDER BY `unit` DESC [ RunTime:0.010278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59671235 LIMIT 2 [ RunTime:0.000963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59671235 ORDER BY `minOrder` ASC [ RunTime:0.001364s ]
select * from pdf where partno='FTSH-105-01-S-DV-K-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-S-DV-K-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014960s ]
SELECT `id` FROM `stock` WHERE `id` <> 59671235 AND `partno` = 'FTSH-105-01-S-DV-K-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.033039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19793869 [ RunTime:0.013484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59668804 LIMIT 5 [ RunTime:0.019165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59668804 ORDER BY `minOrder` ASC [ RunTime:0.041905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59668804 ORDER BY `unit` DESC [ RunTime:0.023142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59668804 LIMIT 2 [ RunTime:0.039093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59668804 ORDER BY `minOrder` ASC [ RunTime:0.013734s ]
select * from pdf where partno='FTSH-105-01-S-DV-007-K-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.025248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-S-DV-007-K-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.017739s ]
SELECT `id` FROM `stock` WHERE `id` <> 59668804 AND `partno` = 'FTSH-105-01-S-DV-007-K-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.012572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16206278 [ RunTime:0.023127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59668117 LIMIT 5 [ RunTime:0.025890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59668117 ORDER BY `minOrder` ASC [ RunTime:0.022815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59668117 ORDER BY `unit` DESC [ RunTime:0.034969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59668117 LIMIT 2 [ RunTime:0.020988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59668117 ORDER BY `minOrder` ASC [ RunTime:0.065726s ]
select * from pdf where partno='FTSH-105-01-S-DV-007-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.024052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-S-DV-007-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002538s ]
SELECT `id` FROM `stock` WHERE `id` <> 59668117 AND `partno` = 'FTSH-105-01-S-DV-007-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16210574 [ RunTime:0.021254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59668051 LIMIT 5 [ RunTime:0.027929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59668051 ORDER BY `minOrder` ASC [ RunTime:0.027964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59668051 ORDER BY `unit` DESC [ RunTime:0.059467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59668051 LIMIT 2 [ RunTime:0.067271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59668051 ORDER BY `minOrder` ASC [ RunTime:0.043227s ]
select * from pdf where partno='FTSH-105-01-S-DV-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.026493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-S-DV-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.035455s ]
SELECT `id` FROM `stock` WHERE `id` <> 59668051 AND `partno` = 'FTSH-105-01-S-DV-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.029613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16205905 [ RunTime:0.023780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59667218 LIMIT 5 [ RunTime:0.048591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59667218 ORDER BY `minOrder` ASC [ RunTime:0.037941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59667218 ORDER BY `unit` DESC [ RunTime:0.020257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59667218 LIMIT 2 [ RunTime:0.041674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59667218 ORDER BY `minOrder` ASC [ RunTime:0.010000s ]
select * from pdf where partno='FTSH-105-01-S-DV-007-K-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.028486s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-S-DV-007-K-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.028798s ]
SELECT `id` FROM `stock` WHERE `id` <> 59667218 AND `partno` = 'FTSH-105-01-S-DV-007-K-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.030547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16207611 [ RunTime:0.012693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59665099 LIMIT 5 [ RunTime:0.055290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59665099 ORDER BY `minOrder` ASC [ RunTime:0.046827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59665099 ORDER BY `unit` DESC [ RunTime:0.033747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59665099 LIMIT 2 [ RunTime:0.003025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59665099 ORDER BY `minOrder` ASC [ RunTime:0.017358s ]
select * from pdf where partno='FTSH-105-01-S-DV-K-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.028747s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-S-DV-K-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014921s ]
SELECT `id` FROM `stock` WHERE `id` <> 59665099 AND `partno` = 'FTSH-105-01-S-DV-K-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.029672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19792723 [ RunTime:0.064008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59664532 LIMIT 5 [ RunTime:0.031077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59664532 ORDER BY `minOrder` ASC [ RunTime:0.055825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59664532 ORDER BY `unit` DESC [ RunTime:0.031675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59664532 LIMIT 2 [ RunTime:0.017517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59664532 ORDER BY `minOrder` ASC [ RunTime:0.021504s ]
select * from pdf where partno='FTSH-105-01-S-D-RA-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.018135s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-S-D-RA-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008795s ]
SELECT `id` FROM `stock` WHERE `id` <> 59664532 AND `partno` = 'FTSH-105-01-S-D-RA-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.013043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19797664 [ RunTime:0.037035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59660630 LIMIT 5 [ RunTime:0.044764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59660630 ORDER BY `minOrder` ASC [ RunTime:0.024409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59660630 ORDER BY `unit` DESC [ RunTime:0.009668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59660630 LIMIT 2 [ RunTime:0.033907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59660630 ORDER BY `minOrder` ASC [ RunTime:0.015501s ]
select * from pdf where partno='FTSH-105-01-S-DV-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-S-DV-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012731s ]
SELECT `id` FROM `stock` WHERE `id` <> 59660630 AND `partno` = 'FTSH-105-01-S-DV-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.021534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59660595 LIMIT 5 [ RunTime:0.050389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59660595 ORDER BY `minOrder` ASC [ RunTime:0.004843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59660595 ORDER BY `unit` DESC [ RunTime:0.012083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59660595 LIMIT 2 [ RunTime:0.001679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59660595 ORDER BY `minOrder` ASC [ RunTime:0.005840s ]
select * from pdf where partno='FTSH-105-01-S-DV-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-S-DV-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014710s ]
SELECT `id` FROM `stock` WHERE `id` <> 59660595 AND `partno` = 'FTSH-105-01-S-DV-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.014390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19786086 [ RunTime:0.037984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59660520 LIMIT 5 [ RunTime:0.033016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59660520 ORDER BY `minOrder` ASC [ RunTime:0.064408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59660520 ORDER BY `unit` DESC [ RunTime:0.040928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59660520 LIMIT 2 [ RunTime:0.018589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59660520 ORDER BY `minOrder` ASC [ RunTime:0.013114s ]
select * from pdf where partno='FTSH-105-01-S-DH' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.037488s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-S-DH' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.023117s ]
SELECT `id` FROM `stock` WHERE `id` <> 59660520 AND `partno` = 'FTSH-105-01-S-DH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.024069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19794454 [ RunTime:0.029946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59659854 LIMIT 5 [ RunTime:0.045486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59659854 ORDER BY `minOrder` ASC [ RunTime:0.025154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59659854 ORDER BY `unit` DESC [ RunTime:0.012507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59659854 LIMIT 2 [ RunTime:0.043021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59659854 ORDER BY `minOrder` ASC [ RunTime:0.024129s ]
select * from pdf where partno='FTSH-105-01-S-DV-K-A-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.023976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-S-DV-K-A-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.040923s ]
SELECT `id` FROM `stock` WHERE `id` <> 59659854 AND `partno` = 'FTSH-105-01-S-DV-K-A-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.046608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59659720 LIMIT 5 [ RunTime:0.005745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59659720 ORDER BY `minOrder` ASC [ RunTime:0.024035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59659720 ORDER BY `unit` DESC [ RunTime:0.039716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59659720 LIMIT 2 [ RunTime:0.032555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59659720 ORDER BY `minOrder` ASC [ RunTime:0.027162s ]
select * from pdf where partno='FTSH-105-01-S-DV-K-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.034017s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-S-DV-K-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.020076s ]
SELECT `id` FROM `stock` WHERE `id` <> 59659720 AND `partno` = 'FTSH-105-01-S-DV-K-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15479931 [ RunTime:0.024556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59659233 LIMIT 5 [ RunTime:0.046022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59659233 ORDER BY `minOrder` ASC [ RunTime:0.028641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59659233 ORDER BY `unit` DESC [ RunTime:0.023960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59659233 LIMIT 2 [ RunTime:0.010165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59659233 ORDER BY `minOrder` ASC [ RunTime:0.029634s ]
select * from pdf where partno='FTSH-105-01-S-DH-A-C-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.031964s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-S-DH-A-C-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.032995s ]
SELECT `id` FROM `stock` WHERE `id` <> 59659233 AND `partno` = 'FTSH-105-01-S-DH-A-C-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.022995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59659182 LIMIT 5 [ RunTime:0.040351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59659182 ORDER BY `minOrder` ASC [ RunTime:0.011204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59659182 ORDER BY `unit` DESC [ RunTime:0.014047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59659182 LIMIT 2 [ RunTime:0.021264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59659182 ORDER BY `minOrder` ASC [ RunTime:0.013012s ]
select * from pdf where partno='FTSH-105-01-S-DH-A-C-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.028871s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-S-DH-A-C-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.015904s ]
SELECT `id` FROM `stock` WHERE `id` <> 59659182 AND `partno` = 'FTSH-105-01-S-DH-A-C-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.021402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19785180 [ RunTime:0.023610s ]
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 'FTSH-105-01-S-D%' OR `brand` LIKE 'FTSH-105-01-S-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042669s ]
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 'FTSH-105-01-S-D%' OR `brand` LIKE 'FTSH-105-01-S-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.074211s ]
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 'FTSH-105-01-S-D%' OR `brand` LIKE 'FTSH-105-01-S-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012004s ]
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 'FTSH-105-01-S-D%' OR `brand` LIKE 'FTSH-105-01-S-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041164s ]
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 'FTSH-105-01-S-D%' OR `brand` LIKE 'FTSH-105-01-S-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034987s ]
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 'FTSH-105-01-S-D%' OR `brand` LIKE 'FTSH-105-01-S-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058337s ]
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 'FTSH-105-01-S-D%' OR `brand` LIKE 'FTSH-105-01-S-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061903s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'FTSH-105-01-S-D%' OR `brand` LIKE 'FTSH-105-01-S-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.094314s ]