SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312012 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312012 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347572,88995,565479,143009,858561,11427,795587,1026587,129510,773317,738257,771689,415219,463104,292965,462528,655892,957784,617458,366177,259787,711007,678812,345924,707244,711448,286391,629528,561348,55891,911540,278313,252800,189626,344807,696010,740889,660239,280315,275543,930524,847199,145447,357611,370244,360943,387413,574592,992934,980379,976680,135915,95018,900809,320069,596130,181458,176284,170678,773229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]