SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409381 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409381 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456193,386921,390458,432492,524407,129448,918005,197150,203046,990628,193434,946718,550723,563894,863812,63608,663810,540778,400096,543162,614819,794433,758568,784164,883599,172924,714240,307274,190282,31325,542346,335989,544971,459855,103841,250296,519083,486715,592995,984579,204919,665007,625846,890507,568569,664293,205865,745888,884060,967293,412552,11985,82150,127718,348723,30656,962235,587575,687815,854794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]