SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465196 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465196 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312543,180253,956010,41659,690322,973567,629572,121996,110248,920447,523046,397567,654188,340367,908177,915668,268963,74513,466358,297432,451000,749358,8934,1044739,605103,944109,151945,1037770,829044,850998,310895,957575,20956,761379,644903,129424,166862,66945,603725,597901,504052,558190,660577,59154,513227,241988,11451,254412,562989,426478,336808,314064,68301,814766,62260,465774,539752,122973,1046838,300187) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]