SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517975 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517975 [ RunTime:0.001466s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403177,198319,652258,627120,321818,998540,681585,498419,179466,729018,263540,706310,538918,130325,870477,49542,858719,521733,948470,148874,706877,1029715,794277,10070,878984,1046878,386866,352912,975969,461027,13114,817591,637318,212641,78556,458616,499838,890705,828072,620859,527439,382146,870655,119162,757930,556723,665631,894648,43905,409909,160331,193275,858800,386957,625785,1002844,410776,638394,367468,850685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]