SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468946 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468946 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376059,765659,168688,729965,754488,132139,209964,7810,807999,86076,540870,581878,626923,440569,685698,1041223,1019199,740074,379419,740293,743248,794665,484394,684862,1018356,620453,360959,489084,546133,620650,711090,683644,73828,193722,667976,228645,936550,985191,136288,430702,243576,12101,279317,134284,191262,805519,738833,743846,1003207,751100,199965,605199,1047474,980362,728771,578661,855130,51816,68766,333566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]