SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356058 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356058 [ RunTime:0.001992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526640,765806,912842,687537,402690,408132,566333,572585,137413,664033,646334,1027618,701236,706348,621950,413054,259215,674211,326434,90624,702281,254500,382904,389004,602265,827484,109818,624859,183055,671024,296032,679568,27543,1037381,700405,835841,116375,520660,125893,291955,923376,961591,691526,751383,775722,109851,1027686,189705,305587,470929,109223,800777,223723,611928,382812,652455,1003548,21925,690170,93708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]