SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001557s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284814 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284814 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946227,299002,386027,4721,579089,111343,135195,966734,348643,20342,953574,172118,23728,100533,40476,315300,368328,905211,885401,926697,322191,5034,65660,172559,387506,808314,423200,58774,234465,17014,860621,1007951,822669,371437,904084,237504,384536,1034870,417531,379369,560890,908224,351177,533840,485274,283181,289099,25083,218644,88006,331434,274154,890368,745437,663126,920912,514885,947212,197400,360678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]