SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506838 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506838 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812618,679274,117084,375703,406668,492504,504965,279337,1027495,604303,414923,269499,983349,35425,439060,158650,524452,894798,940412,542681,419835,82257,571820,508201,413505,557374,943308,37315,947345,300715,334407,658669,794905,793136,914779,417376,145281,33357,1000597,483672,914466,575377,18216,884231,646713,695881,567739,42743,652335,281958,760806,513652,740964,108982,22575,787635,937020,674991,801173,303028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]