SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402992 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402992 [ RunTime:0.002581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134158,649667,391256,739923,12620,340202,204068,602878,184530,413115,308132,360776,1009256,539208,411071,144415,322092,614891,592970,301482,764254,269943,149795,603060,204376,498093,867020,760080,997198,761564,1042344,154373,499056,17038,521989,94942,611070,777583,631688,722301,1002067,296124,5270,966320,940995,876732,972982,660121,1020753,1003386,581374,501417,465170,934456,867397,661546,1002608,1019424,266102,96163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402992 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402992 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000839s ]