SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002551s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.15' , `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=DT04-4P&search=1' [ RunTime:0.009098s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001350s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001044s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001458s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.15' ) [ RunTime:0.003572s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001159s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000300s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001309s ]
SELECT * FROM `stock_search` WHERE `partno` = 'DT04-4P' LIMIT 1 [ RunTime:0.007053s ]
UPDATE `stock_search` SET `count` = 14 , `updatetime` = '2026-08-14 02:07:44' WHERE `partno` = 'DT04-4P' [ RunTime:0.007816s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001399s ]
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 'DT04-4P%' OR `brand` LIKE 'DT04-4P%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014676s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11494583 LIMIT 5 [ RunTime:0.022393s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11494583 ORDER BY `minOrder` ASC [ RunTime:0.005264s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11494583 ORDER BY `unit` DESC [ RunTime:0.015723s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11494583 LIMIT 2 [ RunTime:0.010596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11494583 ORDER BY `minOrder` ASC [ RunTime:0.017357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11494778 LIMIT 5 [ RunTime:0.012985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11494778 ORDER BY `minOrder` ASC [ RunTime:0.022563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11494778 ORDER BY `unit` DESC [ RunTime:0.018755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11494778 LIMIT 2 [ RunTime:0.026705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11494778 ORDER BY `minOrder` ASC [ RunTime:0.013549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12628967 LIMIT 5 [ RunTime:0.044415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628967 ORDER BY `minOrder` ASC [ RunTime:0.043570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12628967 ORDER BY `unit` DESC [ RunTime:0.013472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12628967 LIMIT 2 [ RunTime:0.022833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628967 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12628989 LIMIT 5 [ RunTime:0.037490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628989 ORDER BY `minOrder` ASC [ RunTime:0.019808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12628989 ORDER BY `unit` DESC [ RunTime:0.041564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12628989 LIMIT 2 [ RunTime:0.022363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628989 ORDER BY `minOrder` ASC [ RunTime:0.015118s ]
select * from pdf where partno='DT04-4P-CL06' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.022124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12629890 LIMIT 5 [ RunTime:0.015568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12629890 ORDER BY `minOrder` ASC [ RunTime:0.008007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12629890 ORDER BY `unit` DESC [ RunTime:0.035027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12629890 LIMIT 2 [ RunTime:0.002544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12629890 ORDER BY `minOrder` ASC [ RunTime:0.026141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11494615 LIMIT 5 [ RunTime:0.012888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11494615 ORDER BY `minOrder` ASC [ RunTime:0.026180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11494615 ORDER BY `unit` DESC [ RunTime:0.017340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11494615 LIMIT 2 [ RunTime:0.049914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11494615 ORDER BY `minOrder` ASC [ RunTime:0.010449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11495598 LIMIT 5 [ RunTime:0.048520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495598 ORDER BY `minOrder` ASC [ RunTime:0.034809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11495598 ORDER BY `unit` DESC [ RunTime:0.036376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11495598 LIMIT 2 [ RunTime:0.027950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495598 ORDER BY `minOrder` ASC [ RunTime:0.002741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12628972 LIMIT 5 [ RunTime:0.017822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628972 ORDER BY `minOrder` ASC [ RunTime:0.022222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12628972 ORDER BY `unit` DESC [ RunTime:0.026299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12628972 LIMIT 2 [ RunTime:0.018506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628972 ORDER BY `minOrder` ASC [ RunTime:0.009800s ]
select * from pdf where partno='DT04-4P-EP13' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.004641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11496780 LIMIT 5 [ RunTime:0.003883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11496780 ORDER BY `minOrder` ASC [ RunTime:0.043285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11496780 ORDER BY `unit` DESC [ RunTime:0.013099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11496780 LIMIT 2 [ RunTime:0.030818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11496780 ORDER BY `minOrder` ASC [ RunTime:0.001536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11494654 LIMIT 5 [ RunTime:0.013797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11494654 ORDER BY `minOrder` ASC [ RunTime:0.005610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11494654 ORDER BY `unit` DESC [ RunTime:0.005681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11494654 LIMIT 2 [ RunTime:0.026876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11494654 ORDER BY `minOrder` ASC [ RunTime:0.005531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12629315 LIMIT 5 [ RunTime:0.009301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12629315 ORDER BY `minOrder` ASC [ RunTime:0.008750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12629315 ORDER BY `unit` DESC [ RunTime:0.008144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12629315 LIMIT 2 [ RunTime:0.012486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12629315 ORDER BY `minOrder` ASC [ RunTime:0.017277s ]
select * from pdf where partno='DT04-4P-P021' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.011281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12628371 LIMIT 5 [ RunTime:0.015271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628371 ORDER BY `minOrder` ASC [ RunTime:0.008876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12628371 ORDER BY `unit` DESC [ RunTime:0.011702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12628371 LIMIT 2 [ RunTime:0.010998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628371 ORDER BY `minOrder` ASC [ RunTime:0.010015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12626049 LIMIT 5 [ RunTime:0.001282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12626049 ORDER BY `minOrder` ASC [ RunTime:0.002958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12626049 ORDER BY `unit` DESC [ RunTime:0.010331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12626049 LIMIT 2 [ RunTime:0.009073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12626049 ORDER BY `minOrder` ASC [ RunTime:0.002614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12625874 LIMIT 5 [ RunTime:0.022919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12625874 ORDER BY `minOrder` ASC [ RunTime:0.007404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12625874 ORDER BY `unit` DESC [ RunTime:0.003478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12625874 LIMIT 2 [ RunTime:0.008113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12625874 ORDER BY `minOrder` ASC [ RunTime:0.002496s ]
select * from pdf where partno='DT04-4P-LE14' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.015752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12625585 LIMIT 5 [ RunTime:0.003074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12625585 ORDER BY `minOrder` ASC [ RunTime:0.001987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12625585 ORDER BY `unit` DESC [ RunTime:0.000439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12625585 LIMIT 2 [ RunTime:0.002529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12625585 ORDER BY `minOrder` ASC [ RunTime:0.004301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12624109 LIMIT 5 [ RunTime:0.001889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12624109 ORDER BY `minOrder` ASC [ RunTime:0.017962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12624109 ORDER BY `unit` DESC [ RunTime:0.007041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12624109 LIMIT 2 [ RunTime:0.013435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12624109 ORDER BY `minOrder` ASC [ RunTime:0.009587s ]
select * from pdf where partno='DT04-4P-P004' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.016885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12619217 LIMIT 5 [ RunTime:0.017723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12619217 ORDER BY `minOrder` ASC [ RunTime:0.027635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12619217 ORDER BY `unit` DESC [ RunTime:0.016426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12619217 LIMIT 2 [ RunTime:0.010118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12619217 ORDER BY `minOrder` ASC [ RunTime:0.003293s ]
select * from pdf where partno='DT04-4P-CE04' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.003090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11495540 LIMIT 5 [ RunTime:0.019493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495540 ORDER BY `minOrder` ASC [ RunTime:0.022938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11495540 ORDER BY `unit` DESC [ RunTime:0.015699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11495540 LIMIT 2 [ RunTime:0.028875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495540 ORDER BY `minOrder` ASC [ RunTime:0.007904s ]
select * from pdf where partno='DT04-4P-C017' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.004152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11495057 LIMIT 5 [ RunTime:0.014005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495057 ORDER BY `minOrder` ASC [ RunTime:0.015938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11495057 ORDER BY `unit` DESC [ RunTime:0.006418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11495057 LIMIT 2 [ RunTime:0.024970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495057 ORDER BY `minOrder` ASC [ RunTime:0.024420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11492494 LIMIT 5 [ RunTime:0.006674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11492494 ORDER BY `minOrder` ASC [ RunTime:0.001287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11492494 ORDER BY `unit` DESC [ RunTime:0.012612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11492494 LIMIT 2 [ RunTime:0.040033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11492494 ORDER BY `minOrder` ASC [ RunTime:0.003068s ]
select * from pdf where partno='DT04-4P-COMPLETE' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.018652s ]
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 'DT04-4P%' OR `brand` LIKE 'DT04-4P%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024119s ]
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 'DT04-4P%' OR `brand` LIKE 'DT04-4P%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59934479 LIMIT 5 [ RunTime:0.045733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59934479 ORDER BY `minOrder` ASC [ RunTime:0.045534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59934479 ORDER BY `unit` DESC [ RunTime:0.052239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59934479 LIMIT 2 [ RunTime:0.047624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59934479 ORDER BY `minOrder` ASC [ RunTime:0.003179s ]
select * from pdf where partno='DT04-4P' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.058999s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002397s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT04-4P' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.046997s ]
SELECT `id` FROM `stock` WHERE `id` <> 59934479 AND `partno` = 'DT04-4P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.039036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59937269 LIMIT 5 [ RunTime:0.051937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937269 ORDER BY `minOrder` ASC [ RunTime:0.081548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59937269 ORDER BY `unit` DESC [ RunTime:0.043943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59937269 LIMIT 2 [ RunTime:0.033296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937269 ORDER BY `minOrder` ASC [ RunTime:0.001089s ]
select * from pdf where partno='DT04-4P-E004' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.073947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT04-4P-E004' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.056623s ]
SELECT `id` FROM `stock` WHERE `id` <> 59937269 AND `partno` = 'DT04-4P-E004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.014759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59945873 LIMIT 5 [ RunTime:0.008756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59945873 ORDER BY `minOrder` ASC [ RunTime:0.012554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59945873 ORDER BY `unit` DESC [ RunTime:0.036354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59945873 LIMIT 2 [ RunTime:0.039170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59945873 ORDER BY `minOrder` ASC [ RunTime:0.015408s ]
select * from pdf where partno='DT04-4P-E008' and brandshort='TE Connectivity' limit 1 [ RunTime:0.019471s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT04-4P-E008' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.056422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59937517 LIMIT 5 [ RunTime:0.045970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937517 ORDER BY `minOrder` ASC [ RunTime:0.060680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59937517 ORDER BY `unit` DESC [ RunTime:0.019349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59937517 LIMIT 2 [ RunTime:0.098684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937517 ORDER BY `minOrder` ASC [ RunTime:0.026970s ]
select * from pdf where partno='DT04-4P-CE03' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.018089s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT04-4P-CE03' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.008345s ]
SELECT `id` FROM `stock` WHERE `id` <> 59937517 AND `partno` = 'DT04-4P-CE03' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.088064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11494615 [ RunTime:0.044085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59937271 LIMIT 5 [ RunTime:0.017188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937271 ORDER BY `minOrder` ASC [ RunTime:0.032379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59937271 ORDER BY `unit` DESC [ RunTime:0.024914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59937271 LIMIT 2 [ RunTime:0.041882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937271 ORDER BY `minOrder` ASC [ RunTime:0.016153s ]
select * from pdf where partno='DT04-4P-CE02' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.002302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT04-4P-CE02' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.029228s ]
SELECT `id` FROM `stock` WHERE `id` <> 59937271 AND `partno` = 'DT04-4P-CE02' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.028189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11488159 [ RunTime:0.058081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59937216 LIMIT 5 [ RunTime:0.012676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937216 ORDER BY `minOrder` ASC [ RunTime:0.024604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59937216 ORDER BY `unit` DESC [ RunTime:0.037131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59937216 LIMIT 2 [ RunTime:0.047660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937216 ORDER BY `minOrder` ASC [ RunTime:0.012925s ]
select * from pdf where partno='DT04-4P-C015' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.042514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT04-4P-C015' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.033128s ]
SELECT `id` FROM `stock` WHERE `id` <> 59937216 AND `partno` = 'DT04-4P-C015' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.017664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12628371 [ RunTime:0.042040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59937520 LIMIT 5 [ RunTime:0.058803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937520 ORDER BY `minOrder` ASC [ RunTime:0.043937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59937520 ORDER BY `unit` DESC [ RunTime:0.051304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59937520 LIMIT 2 [ RunTime:0.056209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937520 ORDER BY `minOrder` ASC [ RunTime:0.013877s ]
select * from pdf where partno='DT04-4P-E005' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.017754s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT04-4P-E005' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.057217s ]
SELECT `id` FROM `stock` WHERE `id` <> 59937520 AND `partno` = 'DT04-4P-E005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.042212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11494583 [ RunTime:0.015141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59937739 LIMIT 5 [ RunTime:0.014971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937739 ORDER BY `minOrder` ASC [ RunTime:0.014605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59937739 ORDER BY `unit` DESC [ RunTime:0.035981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59937739 LIMIT 2 [ RunTime:0.005903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937739 ORDER BY `minOrder` ASC [ RunTime:0.004228s ]
select * from pdf where partno='DT04-4P-CE01' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.017271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT04-4P-CE01' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.024563s ]
SELECT `id` FROM `stock` WHERE `id` <> 59937739 AND `partno` = 'DT04-4P-CE01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.023092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11494654 [ RunTime:0.033059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59938285 LIMIT 5 [ RunTime:0.024233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938285 ORDER BY `minOrder` ASC [ RunTime:0.007959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59938285 ORDER BY `unit` DESC [ RunTime:0.009317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59938285 LIMIT 2 [ RunTime:0.017146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938285 ORDER BY `minOrder` ASC [ RunTime:0.014206s ]
select * from pdf where partno='DT04-4P-EP13' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.003356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT04-4P-EP13' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.008357s ]
SELECT `id` FROM `stock` WHERE `id` <> 59938285 AND `partno` = 'DT04-4P-EP13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.035324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12628972 [ RunTime:0.020525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59940537 LIMIT 5 [ RunTime:0.028759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59940537 ORDER BY `minOrder` ASC [ RunTime:0.019786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59940537 ORDER BY `unit` DESC [ RunTime:0.016978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59940537 LIMIT 2 [ RunTime:0.020337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59940537 ORDER BY `minOrder` ASC [ RunTime:0.009258s ]
select * from pdf where partno='DT04-4P-C017' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.004525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT04-4P-C017' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.015627s ]
SELECT `id` FROM `stock` WHERE `id` <> 59940537 AND `partno` = 'DT04-4P-C017' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.014585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11495540 [ RunTime:0.032331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59934623 LIMIT 5 [ RunTime:0.019159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59934623 ORDER BY `minOrder` ASC [ RunTime:0.016506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59934623 ORDER BY `unit` DESC [ RunTime:0.009555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59934623 LIMIT 2 [ RunTime:0.008665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59934623 ORDER BY `minOrder` ASC [ RunTime:0.010476s ]
select * from pdf where partno='DT04-4P-L012' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.014086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT04-4P-L012' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.025563s ]
SELECT `id` FROM `stock` WHERE `id` <> 59934623 AND `partno` = 'DT04-4P-L012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.046264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11488088 [ RunTime:0.030103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59934663 LIMIT 5 [ RunTime:0.014701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59934663 ORDER BY `minOrder` ASC [ RunTime:0.012944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59934663 ORDER BY `unit` DESC [ RunTime:0.001498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59934663 LIMIT 2 [ RunTime:0.014822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59934663 ORDER BY `minOrder` ASC [ RunTime:0.012688s ]
select * from pdf where partno='DT04-4P-CL03' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.011437s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT04-4P-CL03' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.014208s ]
SELECT `id` FROM `stock` WHERE `id` <> 59934663 AND `partno` = 'DT04-4P-CL03' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.026523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59938090 LIMIT 5 [ RunTime:0.056206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938090 ORDER BY `minOrder` ASC [ RunTime:0.033680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59938090 ORDER BY `unit` DESC [ RunTime:0.053364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59938090 LIMIT 2 [ RunTime:0.053218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938090 ORDER BY `minOrder` ASC [ RunTime:0.005281s ]
select * from pdf where partno='DT04-4P-CE09' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.032307s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT04-4P-CE09' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.057711s ]
SELECT `id` FROM `stock` WHERE `id` <> 59938090 AND `partno` = 'DT04-4P-CE09' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.035827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11494778 [ RunTime:0.027653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59945652 LIMIT 5 [ RunTime:0.033010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59945652 ORDER BY `minOrder` ASC [ RunTime:0.035167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59945652 ORDER BY `unit` DESC [ RunTime:0.035964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59945652 LIMIT 2 [ RunTime:0.058876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59945652 ORDER BY `minOrder` ASC [ RunTime:0.041602s ]
select * from pdf where partno='DT04-4P-E003' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.057713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT04-4P-E003' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.012118s ]
SELECT `id` FROM `stock` WHERE `id` <> 59945652 AND `partno` = 'DT04-4P-E003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.082824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59942118 LIMIT 5 [ RunTime:0.047339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59942118 ORDER BY `minOrder` ASC [ RunTime:0.016067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59942118 ORDER BY `unit` DESC [ RunTime:0.023703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59942118 LIMIT 2 [ RunTime:0.026690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59942118 ORDER BY `minOrder` ASC [ RunTime:0.013918s ]
select * from pdf where partno='DT04-4P-EP04' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.015548s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT04-4P-EP04' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.012044s ]
SELECT `id` FROM `stock` WHERE `id` <> 59942118 AND `partno` = 'DT04-4P-EP04' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.029648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59938146 LIMIT 5 [ RunTime:0.046027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938146 ORDER BY `minOrder` ASC [ RunTime:0.013400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59938146 ORDER BY `unit` DESC [ RunTime:0.010018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59938146 LIMIT 2 [ RunTime:0.079688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938146 ORDER BY `minOrder` ASC [ RunTime:0.035432s ]
select * from pdf where partno='DT04-4P-CE04' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.002800s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT04-4P-CE04' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.029045s ]
SELECT `id` FROM `stock` WHERE `id` <> 59938146 AND `partno` = 'DT04-4P-CE04' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.032905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12619217 [ RunTime:0.008661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59934739 LIMIT 5 [ RunTime:0.022248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59934739 ORDER BY `minOrder` ASC [ RunTime:0.032995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59934739 ORDER BY `unit` DESC [ RunTime:0.008875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59934739 LIMIT 2 [ RunTime:0.044811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59934739 ORDER BY `minOrder` ASC [ RunTime:0.043552s ]
select * from pdf where partno='DT04-4P-RT01' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.007671s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT04-4P-RT01' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.018230s ]
SELECT `id` FROM `stock` WHERE `id` <> 59934739 AND `partno` = 'DT04-4P-RT01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.086158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12629890 [ RunTime:0.068721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59938280 LIMIT 5 [ RunTime:0.039948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938280 ORDER BY `minOrder` ASC [ RunTime:0.023080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59938280 ORDER BY `unit` DESC [ RunTime:0.056651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59938280 LIMIT 2 [ RunTime:0.012275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938280 ORDER BY `minOrder` ASC [ RunTime:0.007313s ]
select * from pdf where partno='DT04-4P-LE11' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.040470s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT04-4P-LE11' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.014315s ]
SELECT `id` FROM `stock` WHERE `id` <> 59938280 AND `partno` = 'DT04-4P-LE11' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.036596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12628967 [ RunTime:0.049730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59948251 LIMIT 5 [ RunTime:0.042308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59948251 ORDER BY `minOrder` ASC [ RunTime:0.024954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59948251 ORDER BY `unit` DESC [ RunTime:0.017308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59948251 LIMIT 2 [ RunTime:0.021342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59948251 ORDER BY `minOrder` ASC [ RunTime:0.023160s ]
select * from pdf where partno='DT04-4P-P021' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.011594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT04-4P-P021' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.063962s ]
SELECT `id` FROM `stock` WHERE `id` <> 59948251 AND `partno` = 'DT04-4P-P021' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.034857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12629315 [ RunTime:0.059975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59938344 LIMIT 5 [ RunTime:0.047965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938344 ORDER BY `minOrder` ASC [ RunTime:0.043421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59938344 ORDER BY `unit` DESC [ RunTime:0.018040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59938344 LIMIT 2 [ RunTime:0.055959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59938344 ORDER BY `minOrder` ASC [ RunTime:0.007314s ]
select * from pdf where partno='DT04-4P-CL06' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.003113s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DT04-4P-CL06' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.036703s ]
SELECT `id` FROM `stock` WHERE `id` <> 59938344 AND `partno` = 'DT04-4P-CL06' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.048713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12628989 [ RunTime:0.063187s ]
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 'DT04-4P%' OR `brand` LIKE 'DT04-4P%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050698s ]
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 'DT04-4P%' OR `brand` LIKE 'DT04-4P%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058945s ]
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 'DT04-4P%' OR `brand` LIKE 'DT04-4P%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.068372s ]
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 'DT04-4P%' OR `brand` LIKE 'DT04-4P%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027433s ]
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 'DT04-4P%' OR `brand` LIKE 'DT04-4P%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036039s ]
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 'DT04-4P%' OR `brand` LIKE 'DT04-4P%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005336s ]
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 'DT04-4P%' OR `brand` LIKE 'DT04-4P%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043139s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'DT04-4P%' OR `brand` LIKE 'DT04-4P%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009054s ]