SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414656 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414656 [ RunTime:0.002120s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613627,780312,853731,24785,121971,542037,463291,247978,1041324,370863,1002612,92507,325615,534041,27502,1013440,685830,278723,524280,628663,708834,46495,362267,926379,538572,400098,216221,738615,26567,585483,753375,427690,675966,589704,274724,576238,888810,554246,171830,506423,859879,314488,275328,654936,766687,753657,196831,327750,466204,724629,521246,880190,309145,313705,995002,935902,323124,954841,72119,299752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414656 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414656 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]