SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330213 LIMIT 1 [ RunTime:0.001492s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330213 [ RunTime:0.004178s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (858359,202397,851577,365722,830260,902050,438561,960394,227670,673194,187814,971110,647723,838155,144718,561270,1014401,551232,1034051,788721,303408,643425,402443,856527,163744,196243,448221,245708,676234,326494,63785,891006,501295,999772,48991,111408,880787,231727,346748,102528,496861,487705,498503,33660,1012470,529184,188838,359901,731137,262768,902987,1014211,331942,801160,712572,384413,824243,633027,755920,738482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]