SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519015 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519015 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171735,702525,897208,233990,465221,500754,870706,553810,582561,193180,680081,1020397,10663,719553,1011629,590886,313503,438496,565972,328869,336030,623003,93588,660917,146182,810733,600065,672493,254070,99677,690373,540391,565881,280817,237490,739165,181516,726755,937265,584233,277273,448579,430001,920871,117015,226022,864979,21324,634610,607507,838907,272172,737504,633169,245129,335094,926556,669365,244304,880573) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]