SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044120 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044120 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611037,60409,677441,111502,981727,855008,249257,169573,741986,637312,483655,981173,118912,811462,140312,822720,178743,611385,969974,341664,681567,23099,206646,245416,398399,594880,80094,456099,389526,564422,332664,204309,846472,443047,41683,219303,630648,508692,779208,312012,95329,850149,128773,355268,4718,659609,444908,548513,600214,776430,22279,597438,489497,256304,803638,930474,983423,792368,526931,416872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]