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` = 677807 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 677807 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447126,435206,793065,442033,257483,957630,179661,1011852,780191,710796,305460,951043,1047231,127488,311698,929312,98946,310647,919692,167285,878507,688863,316833,859008,760885,200406,326226,859209,690363,495802,821793,607118,237786,266205,650423,732218,507594,294326,60400,58426,340145,310474,965072,101548,625401,214750,739649,654830,454808,228150,36288,649452,91863,604616,122580,501527,401924,455759,876483,1033842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 677807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 677807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]