SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507810 LIMIT 1 [ RunTime:0.000883s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507810 [ RunTime:0.002392s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464457,279784,577137,111027,740589,187741,577066,760377,713052,832523,980797,879829,709070,1026750,236387,45637,196009,313956,856615,834482,401864,260974,13425,421906,12368,1010363,434370,794128,770506,828212,353093,168111,569025,359731,2309,973951,173240,193090,966639,425511,155997,947030,171423,823862,582240,676591,212801,846936,1019975,70617,313548,739726,934075,666751,181174,204806,452016,996648,262038,153978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]