SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 687217 LIMIT 1 [ RunTime:0.000599s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 687217 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19273,760632,302010,916545,852060,605560,152025,671277,290204,681046,292380,625684,290781,222274,651961,666725,530660,663752,334701,215000,259850,104284,824855,456110,848180,708747,733426,590623,876827,619321,283347,361091,776913,442320,450029,822930,16247,328481,219171,425361,421126,603355,321933,3567,411305,348681,625578,250312,421960,614913,443608,551812,910364,867829,740286,325825,864047,433332,632687,699214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 687217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 687217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]