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` = 337810 LIMIT 1 [ RunTime:0.001142s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 337810 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506467,959037,986612,987539,1012402,894241,310050,270062,252020,567925,923272,564559,587108,678886,891778,7456,68299,699263,583665,794915,536053,13154,372347,405144,890641,879901,549853,605165,70335,578203,660003,653062,6324,809554,34657,840740,118288,128319,405965,810193,770800,680104,240200,930344,233391,1031460,995746,474901,74332,371660,500030,849289,893606,156008,19575,711728,421880,1012278,468845,460439) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 337810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 337810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]