SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 594405 LIMIT 1 [ RunTime:0.004112s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 594405 [ RunTime:0.002141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809956,161293,1046814,638391,4119,729059,835297,861939,625754,659978,120537,751622,165369,1019243,763708,122732,77690,466163,1013183,461784,300214,846625,671670,119775,279103,164799,430044,1010587,659285,605310,334303,935117,624345,718151,469529,756261,973789,568491,651133,322581,474364,457233,32439,311086,751402,213966,347568,863392,572563,425775,114015,1040660,782094,254186,742837,872446,524952,97194,184832,608834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 594405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003825s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 594405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]