SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521781 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521781 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (881633,761112,1031149,867876,705151,329857,735150,612717,1047520,916367,240426,892125,625684,401358,841337,435886,104517,803253,238603,234098,10329,406343,817560,112597,52596,870780,702691,133126,705210,420955,543272,561618,537580,260516,62559,859436,366822,991475,58150,90201,756818,592019,937471,240637,921247,277654,640803,210305,388999,294829,765954,775018,837122,393390,672021,280055,468823,903785,948205,799343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]