SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542226 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542226 [ RunTime:0.002797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (697103,532462,977180,443399,844760,965802,522557,940314,398349,727394,699913,63404,962863,330510,249221,879399,68586,82557,780229,735608,4892,384079,592618,238376,39971,862866,979634,126937,23446,1025037,185524,708600,269721,425948,1009449,418847,380402,876072,1026404,410950,500749,99623,434191,305547,83393,539397,588218,492097,543124,233967,512728,801967,884635,526074,729444,23626,944007,58515,54191,284964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001747s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]