SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 384073 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 384073 [ RunTime:0.003082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541990,718933,506932,499181,199757,281610,137217,655444,675328,698506,514156,1044231,514030,21936,1024419,218538,1038157,649803,819121,917381,279350,402235,929622,25689,786930,732095,419996,19954,850520,58769,974473,103940,907331,1009934,949481,952727,246879,1018168,898213,187695,766424,793648,863480,150328,686311,241327,331809,890308,892258,22798,454320,337651,960174,893135,88710,805429,936510,856113,794626,835888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 384073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 384073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]