SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261110 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261110 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475268,275,190912,657202,672551,947367,164688,816095,727565,23964,17337,818543,917382,146075,723042,786356,487600,408427,1022102,762855,846772,954044,185653,169207,900086,240142,560297,322189,922862,685017,720749,117377,582284,594755,930852,827636,62220,1045838,231661,56763,223332,52223,483080,619066,550394,670674,742044,727251,813363,590948,578507,245721,287435,669260,234656,854317,913254,855755,65587,67892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]