SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518104 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518104 [ RunTime:0.001869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744712,147875,809576,157315,992806,293074,623370,871423,208871,844858,264622,115039,117197,50273,179525,872471,159661,92559,440108,329400,1025771,422013,350152,1025715,412216,120806,517106,917908,503148,231543,722069,117522,840914,801306,920726,491020,906835,360366,355971,500819,488153,231370,330920,740483,677425,492855,12377,197799,1025911,1018516,529726,138518,182881,964098,471597,489903,531071,311004,297237,2506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]