SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 839280 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 839280 [ RunTime:0.001435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035221,231969,249539,384976,696290,102589,218311,355258,33396,719967,188225,290552,865784,949880,241931,522992,981509,389374,619441,835314,1018519,927792,392736,861833,530798,219927,171787,994017,243624,474617,231180,144448,872320,962901,395548,704600,738222,320910,107617,141629,438612,661706,42712,436414,251321,758671,919777,31405,463905,115624,949096,57094,234931,221386,199378,557947,68477,446891,735972,294991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 839280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 839280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]