SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440400 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440400 [ RunTime:0.001477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012824,960304,920936,430865,757339,767551,902303,447559,183224,414840,596010,729498,793005,299433,322248,871900,941251,171407,871498,915406,696420,812341,694391,404640,509635,988511,732131,89223,20627,640677,677868,197988,510640,340803,208957,273244,137997,105714,883299,431140,777127,368483,948494,83224,152192,715063,269852,975200,544719,283770,571175,72767,181155,431454,292576,1007448,143714,136173,236438,701378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]