SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001492s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027770 LIMIT 1 [ RunTime:0.000515s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027770 [ RunTime:0.001896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (790129,654853,84195,646558,683795,555278,910068,1044372,130730,341564,343453,584412,374972,1044334,607936,646896,538180,251076,1007986,189530,664127,1009689,969062,554053,706460,789139,887258,484598,829354,956837,959745,5321,475331,436042,655873,583316,424277,440307,199008,30335,613875,782008,433967,542961,21766,803267,3085,953450,303442,758720,378948,895581,197328,374659,1008097,878240,207154,739232,642698,329436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]