SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520021 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520021 [ RunTime:0.006131s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890003,496098,799271,114299,684549,892017,976388,16402,102617,296398,599253,438758,185292,210157,202965,24717,235495,377403,463347,186028,249995,718040,350515,403567,613099,565794,395932,514806,277928,458562,756144,208148,477799,977523,878739,741656,292923,1028366,709617,350173,184186,486721,744926,912396,288631,174470,949979,401618,124378,215522,823138,1032170,606993,238963,336683,883557,309558,67296,535819,383508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]