SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502712 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502712 [ RunTime:0.001894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477165,1040420,988241,489260,117361,192302,82275,658687,838020,709109,413323,441580,568714,316338,463438,794012,171869,348134,226539,739778,839101,915214,493708,102659,562373,386182,33946,645001,93999,75177,147442,197467,910017,841281,749001,301584,826049,374535,405177,334565,183982,197181,72980,961073,968661,567071,562104,744563,160984,163066,447492,634882,1029695,1034255,742090,870041,805130,809539,509227,385763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]