SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022633 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022633 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294801,649018,418562,725361,87058,702449,386959,849550,1039801,375520,986809,606584,127698,650818,957770,740723,451916,775207,953629,586478,487889,422653,1023505,419731,846263,396287,117918,792235,1044200,973711,509057,953809,820469,891980,891242,222549,527489,751097,116646,711426,486411,195199,946105,524365,812529,990671,569884,696587,557470,150131,521019,134565,397946,704945,927852,18948,126267,778791,219700,382265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022633 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022633 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]