SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515623 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515623 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517620,151994,665684,419941,1043948,139850,296930,498898,849132,23965,762867,342853,348928,63038,276215,566737,113765,648671,641050,610239,378263,525371,67653,789733,1021313,362506,279686,769492,209455,262074,189493,241890,852583,388260,113808,560373,135674,681730,48859,964569,924278,555783,853525,668558,215351,700674,9475,80792,720373,226271,58338,883799,128481,864765,717256,282552,346059,349383,586051,734259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]