SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419925 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419925 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402030,1044227,292324,901433,922394,376725,950240,737303,244684,421820,907083,567843,412156,230200,90157,435358,82663,208118,455099,815440,492284,829124,133141,169007,939312,856003,869985,492377,460050,275417,477183,590969,93501,350755,17729,365806,949344,596532,948420,492505,237562,420868,513559,175918,842193,67789,894290,116658,1018732,611827,653032,869855,885419,799141,120088,177273,29151,104626,467144,867981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419925 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419925 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]