SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344801 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344801 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449314,393547,123876,784995,190097,961746,196367,599499,1043663,563126,531921,87997,409441,45259,178329,1037822,303838,448528,701587,19956,935846,71202,780737,203149,642986,201701,853297,914866,44179,194871,66852,925557,135983,878327,724517,704993,995761,783116,408517,972563,4523,19877,110634,84249,229713,359770,182666,989974,958347,914255,919814,699437,208327,135708,355560,275601,455961,201420,60819,656114) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]