SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53443 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53443 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909848,810534,940653,991498,644554,732853,1004659,282434,423404,190754,587624,385587,895559,337059,270541,854000,685340,801025,365910,217260,191513,11614,1040447,360542,785524,383459,877675,1497,365082,604226,1041483,471581,623664,234477,530497,683046,54297,207747,188564,410867,397066,991003,97237,522061,94346,458330,607386,985009,240052,515435,125055,80146,135952,456662,401917,4086,221611,922410,569035,653053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]