SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30618 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30618 [ RunTime:0.001908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266601,740012,529277,373090,1032828,241169,878766,796610,178549,866942,342009,48662,672064,681601,779942,100725,654468,924298,473875,768522,129568,876069,349922,958059,630096,217379,773231,282322,336831,490763,589458,76038,703470,692551,467583,147366,69540,1022308,302529,547637,259341,118225,647038,14820,568439,720246,1008429,1013543,717438,20948,37753,746974,84077,389947,967066,292318,371568,77158,840138,406738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]