SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001419s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281854 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281854 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (775333,835496,116770,478586,1025417,529489,843322,994731,507951,562513,696480,937093,773198,206240,20896,200325,249292,937473,840054,50959,446123,381496,403387,337607,1012198,551452,125105,88324,834209,44947,179317,247789,860376,687247,950705,850185,181570,980094,125593,489591,308868,93507,337162,526383,158843,570536,444878,392444,315220,900132,672080,438401,42366,672453,756563,367493,846289,424065,364437,602783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]