SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001551s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550035 LIMIT 1 [ RunTime:0.000986s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550035 [ RunTime:0.005078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592393,170747,980778,184114,997,875625,640333,82812,879451,364841,763009,437629,422471,195455,365550,999500,288886,98168,599670,945797,404757,575071,878506,626387,926337,422593,197315,245460,803544,157784,215985,580700,612353,203232,146470,430593,373299,178368,756848,489740,166241,362953,807475,625054,718990,338500,941861,32082,822898,198083,899798,530045,230171,458790,807568,749013,257288,472380,450330,612191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]