SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 244146 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 244146 [ RunTime:0.002835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498994,578999,28958,101716,368210,1034205,5052,7644,315215,683957,33252,1029988,958214,179967,870948,864397,726140,247547,149180,145285,408917,1016592,831931,240094,373757,591887,833867,117441,35631,874726,48761,303068,25226,419823,678482,570909,830747,894919,102615,684572,1040636,212093,507636,844492,974190,229993,976003,599023,665008,744555,873552,1037530,696132,1009359,565619,68817,32435,1017090,98358,381187) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 244146 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 244146 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]