SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417897 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417897 [ RunTime:0.001956s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (634772,541629,50894,72556,532484,177192,41238,940388,819052,513582,156853,410732,499067,205279,58318,406431,353543,877011,764702,82021,523646,981195,147257,896556,276209,85533,804835,810044,912329,160110,739620,121443,1003038,130680,836490,857435,691194,927629,658326,1020880,536236,130237,302466,22383,997396,875449,362009,238897,340746,681947,26418,28317,597162,554558,202677,627487,477358,775691,328882,873415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000789s ]