SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515631 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515631 [ RunTime:0.001478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315648,633755,495806,752437,709593,118717,937564,446392,429287,677221,640791,611673,145972,427847,379242,396392,142781,241885,464128,373564,560101,884641,34408,586039,972508,447994,477558,448721,247558,455787,771062,264864,367345,140177,453771,569025,186447,766798,884556,1023232,957141,306692,1024019,493025,382923,82769,362374,575267,887355,658146,312209,97840,319879,1040636,5943,309918,167931,438576,873516,421616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]