SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001527s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549723 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549723 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826042,1029106,1011864,1018465,614562,961450,1015350,342727,28105,893675,272662,107391,856463,491428,904475,757999,305044,191336,326704,818639,880440,358315,52761,738408,795174,51336,905480,766837,966016,689250,466526,1003087,72464,1046707,910008,203846,237855,849284,661709,730750,712447,556175,908990,329126,465580,624033,1020070,164379,467821,53517,232983,870349,345908,730467,508790,80336,917522,910798,226380,1005186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]