SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4200 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4200 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426337,3221,495324,837521,355683,336354,980944,427798,742198,352636,1005477,197772,994184,195295,966810,12324,12640,1005060,874069,527223,583553,1027506,556078,192498,239272,949330,3187,35912,71177,147300,5140,634385,881973,735295,305483,634724,288231,768225,505275,638586,61351,566921,299496,858696,903932,857693,117249,773980,295154,458366,220050,175439,919082,784643,730721,191629,83932,966416,712522,397713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]