SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029858 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029858 [ RunTime:0.002401s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017008,176569,315667,7085,827432,14736,477853,414427,273386,710971,205404,110417,418162,156185,600358,604523,238183,300360,187604,862419,790602,1022412,942507,28432,748913,437993,895496,481337,474772,592405,523479,352515,236456,6944,46670,632689,657152,530553,794842,738053,411323,412317,934624,977179,684241,233860,528999,506657,223976,955898,567464,253765,41875,398562,388449,923052,1001491,177973,684301,966170) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029858 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029858 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]