SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002519s ]
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 '16303%' OR `brand` LIKE '16303%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.068163s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.021229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605930 LIMIT 5 [ RunTime:0.024329s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605930 ORDER BY `minOrder` ASC [ RunTime:0.021034s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19605930 ORDER BY `unit` DESC [ RunTime:0.068071s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.054362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19605930 LIMIT 2 [ RunTime:0.038413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605930 ORDER BY `minOrder` ASC [ RunTime:0.011283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19640443 LIMIT 5 [ RunTime:0.005536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19640443 ORDER BY `minOrder` ASC [ RunTime:0.078873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19640443 ORDER BY `unit` DESC [ RunTime:0.121228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19640443 LIMIT 2 [ RunTime:0.050306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19640443 ORDER BY `minOrder` ASC [ RunTime:0.017053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19639579 LIMIT 5 [ RunTime:0.051483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19639579 ORDER BY `minOrder` ASC [ RunTime:0.003727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19639579 ORDER BY `unit` DESC [ RunTime:0.028890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19639579 LIMIT 2 [ RunTime:0.026949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19639579 ORDER BY `minOrder` ASC [ RunTime:0.042467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19638573 LIMIT 5 [ RunTime:0.057341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19638573 ORDER BY `minOrder` ASC [ RunTime:0.078376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19638573 ORDER BY `unit` DESC [ RunTime:0.044705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19638573 LIMIT 2 [ RunTime:0.034953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19638573 ORDER BY `minOrder` ASC [ RunTime:0.016055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19637448 LIMIT 5 [ RunTime:0.018106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19637448 ORDER BY `minOrder` ASC [ RunTime:0.084299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19637448 ORDER BY `unit` DESC [ RunTime:0.071605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19637448 LIMIT 2 [ RunTime:0.044728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19637448 ORDER BY `minOrder` ASC [ RunTime:0.052619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19636111 LIMIT 5 [ RunTime:0.075875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636111 ORDER BY `minOrder` ASC [ RunTime:0.083355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19636111 ORDER BY `unit` DESC [ RunTime:0.074833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19636111 LIMIT 2 [ RunTime:0.065052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636111 ORDER BY `minOrder` ASC [ RunTime:0.010654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19633113 LIMIT 5 [ RunTime:0.050825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19633113 ORDER BY `minOrder` ASC [ RunTime:0.037229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19633113 ORDER BY `unit` DESC [ RunTime:0.011771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19633113 LIMIT 2 [ RunTime:0.038991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19633113 ORDER BY `minOrder` ASC [ RunTime:0.020550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19631442 LIMIT 5 [ RunTime:0.012476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19631442 ORDER BY `minOrder` ASC [ RunTime:0.025323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19631442 ORDER BY `unit` DESC [ RunTime:0.040230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19631442 LIMIT 2 [ RunTime:0.015869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19631442 ORDER BY `minOrder` ASC [ RunTime:0.038533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19629358 LIMIT 5 [ RunTime:0.067733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19629358 ORDER BY `minOrder` ASC [ RunTime:0.109696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19629358 ORDER BY `unit` DESC [ RunTime:0.031842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19629358 LIMIT 2 [ RunTime:0.027581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19629358 ORDER BY `minOrder` ASC [ RunTime:0.013810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15448869 LIMIT 5 [ RunTime:0.023609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15448869 ORDER BY `minOrder` ASC [ RunTime:0.011893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15448869 ORDER BY `unit` DESC [ RunTime:0.026069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15448869 LIMIT 2 [ RunTime:0.014427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15448869 ORDER BY `minOrder` ASC [ RunTime:0.030433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11434208 LIMIT 5 [ RunTime:0.015605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11434208 ORDER BY `minOrder` ASC [ RunTime:0.018795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11434208 ORDER BY `unit` DESC [ RunTime:0.013978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11434208 LIMIT 2 [ RunTime:0.018156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11434208 ORDER BY `minOrder` ASC [ RunTime:0.002850s ]
select * from pdf where partno='16303-3' and brandshort='Eaton - Bussmann Electrical Division' limit 1 [ RunTime:0.026505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11434176 LIMIT 5 [ RunTime:0.053969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11434176 ORDER BY `minOrder` ASC [ RunTime:0.027265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11434176 ORDER BY `unit` DESC [ RunTime:0.011015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11434176 LIMIT 2 [ RunTime:0.010173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11434176 ORDER BY `minOrder` ASC [ RunTime:0.011548s ]
select * from pdf where partno='16303-2' and brandshort='Eaton - Bussmann Electrical Division' limit 1 [ RunTime:0.005241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11434137 LIMIT 5 [ RunTime:0.012285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11434137 ORDER BY `minOrder` ASC [ RunTime:0.031364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11434137 ORDER BY `unit` DESC [ RunTime:0.015556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11434137 LIMIT 2 [ RunTime:0.017945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11434137 ORDER BY `minOrder` ASC [ RunTime:0.006348s ]
select * from pdf where partno='16303-1' and brandshort='Eaton - Bussmann Electrical Division' limit 1 [ RunTime:0.028791s ]
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 '16303%' OR `brand` LIKE '16303%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032635s ]
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 '16303%' OR `brand` LIKE '16303%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.066274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57658361 LIMIT 5 [ RunTime:0.046613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57658361 ORDER BY `minOrder` ASC [ RunTime:0.054169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57658361 ORDER BY `unit` DESC [ RunTime:0.035028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57658361 LIMIT 2 [ RunTime:0.068613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57658361 ORDER BY `minOrder` ASC [ RunTime:0.027321s ]
select * from pdf where partno='16303' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.028463s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002379s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '16303' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.039750s ]
SELECT `id` FROM `stock` WHERE `id` <> 57658361 AND `partno` = '16303' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.014577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54168298 LIMIT 5 [ RunTime:0.022386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54168298 ORDER BY `minOrder` ASC [ RunTime:0.046627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54168298 ORDER BY `unit` DESC [ RunTime:0.036477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54168298 LIMIT 2 [ RunTime:0.038523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54168298 ORDER BY `minOrder` ASC [ RunTime:0.026831s ]
select * from pdf where partno='16303-3' and brandshort='Eaton - Bussmann Electrical Division' limit 1 [ RunTime:0.007253s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '16303-3' OR `brand` LIKE 'Eaton - Bussmann Electrical Division%' ) ) LIMIT 1 [ RunTime:0.015560s ]
SELECT `id` FROM `stock` WHERE `id` <> 54168298 AND `partno` = '16303-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - bussmann electrical division%' ) [ RunTime:0.033983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11434208 [ RunTime:0.027389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54168167 LIMIT 5 [ RunTime:0.007303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54168167 ORDER BY `minOrder` ASC [ RunTime:0.012660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54168167 ORDER BY `unit` DESC [ RunTime:0.042059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54168167 LIMIT 2 [ RunTime:0.023798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54168167 ORDER BY `minOrder` ASC [ RunTime:0.018481s ]
select * from pdf where partno='16303-2' and brandshort='Eaton - Bussmann Electrical Division' limit 1 [ RunTime:0.001701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '16303-2' OR `brand` LIKE 'Eaton - Bussmann Electrical Division%' ) ) LIMIT 1 [ RunTime:0.014819s ]
SELECT `id` FROM `stock` WHERE `id` <> 54168167 AND `partno` = '16303-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - bussmann electrical division%' ) [ RunTime:0.015443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11434176 [ RunTime:0.023467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54168034 LIMIT 5 [ RunTime:0.024889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54168034 ORDER BY `minOrder` ASC [ RunTime:0.019159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54168034 ORDER BY `unit` DESC [ RunTime:0.050059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54168034 LIMIT 2 [ RunTime:0.023489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54168034 ORDER BY `minOrder` ASC [ RunTime:0.001946s ]
select * from pdf where partno='16303-1' and brandshort='Eaton - Bussmann Electrical Division' limit 1 [ RunTime:0.012596s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '16303-1' OR `brand` LIKE 'Eaton - Bussmann Electrical Division%' ) ) LIMIT 1 [ RunTime:0.025564s ]
SELECT `id` FROM `stock` WHERE `id` <> 54168034 AND `partno` = '16303-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - bussmann electrical division%' ) [ RunTime:0.053938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11434137 [ RunTime:0.029663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53713106 LIMIT 5 [ RunTime:0.022712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53713106 ORDER BY `minOrder` ASC [ RunTime:0.008266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53713106 ORDER BY `unit` DESC [ RunTime:0.032120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53713106 LIMIT 2 [ RunTime:0.028906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53713106 ORDER BY `minOrder` ASC [ RunTime:0.005470s ]
select * from pdf where partno='1630390000' and brandshort='Weidmüller' limit 1 [ RunTime:0.005926s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630390000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.024589s ]
SELECT `id` FROM `stock` WHERE `id` <> 53713106 AND `partno` = '1630390000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.007036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19640443 [ RunTime:0.086697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53711647 LIMIT 5 [ RunTime:0.030861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53711647 ORDER BY `minOrder` ASC [ RunTime:0.050998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53711647 ORDER BY `unit` DESC [ RunTime:0.011672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53711647 LIMIT 2 [ RunTime:0.059146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53711647 ORDER BY `minOrder` ASC [ RunTime:0.018737s ]
select * from pdf where partno='1630380000' and brandshort='Weidmüller' limit 1 [ RunTime:0.028499s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630380000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.014049s ]
SELECT `id` FROM `stock` WHERE `id` <> 53711647 AND `partno` = '1630380000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.010221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19639579 [ RunTime:0.015118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53710191 LIMIT 5 [ RunTime:0.050175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53710191 ORDER BY `minOrder` ASC [ RunTime:0.064386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53710191 ORDER BY `unit` DESC [ RunTime:0.027408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53710191 LIMIT 2 [ RunTime:0.043264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53710191 ORDER BY `minOrder` ASC [ RunTime:0.027911s ]
select * from pdf where partno='1630370000' and brandshort='Weidmüller' limit 1 [ RunTime:0.010644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630370000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.031785s ]
SELECT `id` FROM `stock` WHERE `id` <> 53710191 AND `partno` = '1630370000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.011637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19638573 [ RunTime:0.035820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53708477 LIMIT 5 [ RunTime:0.008976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53708477 ORDER BY `minOrder` ASC [ RunTime:0.025317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53708477 ORDER BY `unit` DESC [ RunTime:0.025404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53708477 LIMIT 2 [ RunTime:0.031289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53708477 ORDER BY `minOrder` ASC [ RunTime:0.007400s ]
select * from pdf where partno='1630360000' and brandshort='Weidmüller' limit 1 [ RunTime:0.009240s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630360000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.015038s ]
SELECT `id` FROM `stock` WHERE `id` <> 53708477 AND `partno` = '1630360000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.011468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19637448 [ RunTime:0.009561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53706593 LIMIT 5 [ RunTime:0.009280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53706593 ORDER BY `minOrder` ASC [ RunTime:0.036264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53706593 ORDER BY `unit` DESC [ RunTime:0.018626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53706593 LIMIT 2 [ RunTime:0.031174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53706593 ORDER BY `minOrder` ASC [ RunTime:0.002465s ]
select * from pdf where partno='1630350000' and brandshort='Weidmüller' limit 1 [ RunTime:0.017470s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630350000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.011098s ]
SELECT `id` FROM `stock` WHERE `id` <> 53706593 AND `partno` = '1630350000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.018480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19636111 [ RunTime:0.023891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53704524 LIMIT 5 [ RunTime:0.029201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53704524 ORDER BY `minOrder` ASC [ RunTime:0.032398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53704524 ORDER BY `unit` DESC [ RunTime:0.015899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53704524 LIMIT 2 [ RunTime:0.029386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53704524 ORDER BY `minOrder` ASC [ RunTime:0.005105s ]
select * from pdf where partno='1630340000' and brandshort='Weidmüller' limit 1 [ RunTime:0.006810s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630340000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.062006s ]
SELECT `id` FROM `stock` WHERE `id` <> 53704524 AND `partno` = '1630340000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.028576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15448869 [ RunTime:0.052613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53702199 LIMIT 5 [ RunTime:0.004901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53702199 ORDER BY `minOrder` ASC [ RunTime:0.014576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53702199 ORDER BY `unit` DESC [ RunTime:0.009391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53702199 LIMIT 2 [ RunTime:0.026769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53702199 ORDER BY `minOrder` ASC [ RunTime:0.009095s ]
select * from pdf where partno='1630330000' and brandshort='Weidmüller' limit 1 [ RunTime:0.015531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630330000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.015784s ]
SELECT `id` FROM `stock` WHERE `id` <> 53702199 AND `partno` = '1630330000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.007632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19633113 [ RunTime:0.003274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53699787 LIMIT 5 [ RunTime:0.010664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53699787 ORDER BY `minOrder` ASC [ RunTime:0.016194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53699787 ORDER BY `unit` DESC [ RunTime:0.014947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53699787 LIMIT 2 [ RunTime:0.014334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53699787 ORDER BY `minOrder` ASC [ RunTime:0.000674s ]
select * from pdf where partno='1630320000' and brandshort='Weidmüller' limit 1 [ RunTime:0.011181s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630320000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.019975s ]
SELECT `id` FROM `stock` WHERE `id` <> 53699787 AND `partno` = '1630320000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.008008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19631442 [ RunTime:0.008373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53697091 LIMIT 5 [ RunTime:0.005037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53697091 ORDER BY `minOrder` ASC [ RunTime:0.007224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53697091 ORDER BY `unit` DESC [ RunTime:0.017121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53697091 LIMIT 2 [ RunTime:0.003638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53697091 ORDER BY `minOrder` ASC [ RunTime:0.010908s ]
select * from pdf where partno='1630310000' and brandshort='Weidmüller' limit 1 [ RunTime:0.008687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630310000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.028547s ]
SELECT `id` FROM `stock` WHERE `id` <> 53697091 AND `partno` = '1630310000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.007866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19629358 [ RunTime:0.007274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53667428 LIMIT 5 [ RunTime:0.024686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53667428 ORDER BY `minOrder` ASC [ RunTime:0.010060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53667428 ORDER BY `unit` DESC [ RunTime:0.006243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53667428 LIMIT 2 [ RunTime:0.014601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53667428 ORDER BY `minOrder` ASC [ RunTime:0.003655s ]
select * from pdf where partno='1630300000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1630300000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.017562s ]
SELECT `id` FROM `stock` WHERE `id` <> 53667428 AND `partno` = '1630300000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605930 [ RunTime:0.000827s ]
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 '16303%' OR `brand` LIKE '16303%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005612s ]
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 '16303%' OR `brand` LIKE '16303%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003821s ]
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 '16303%' OR `brand` LIKE '16303%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021046s ]
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 '16303%' OR `brand` LIKE '16303%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020058s ]
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 '16303%' OR `brand` LIKE '16303%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008322s ]
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 '16303%' OR `brand` LIKE '16303%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023558s ]
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 '16303%' OR `brand` LIKE '16303%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023034s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '16303%' OR `brand` LIKE '16303%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.018384s ]