SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807217 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807217 [ RunTime:0.001943s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312129,230577,675756,941185,111533,723390,476363,530304,707412,450086,45076,571229,409137,268369,605003,1007884,229810,510984,713209,177907,451595,94363,387713,100787,571217,748266,338130,167296,425125,214940,1003460,664279,318056,58948,155219,808938,1013968,227737,235845,717020,527851,685774,473192,119949,341859,1031242,14237,1008240,558433,356609,276798,1043849,355044,274930,837634,719449,70765,647421,167107,352539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]