SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001564s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 910163 LIMIT 1 [ RunTime:0.000916s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 910163 [ RunTime:0.003964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217173,137685,821162,459890,281908,530661,717128,997618,613705,1016701,960848,728530,113852,520934,330700,570145,896937,898761,589056,983322,1048544,206224,280738,903402,1003830,741811,117213,568309,393132,991465,948440,689359,287056,198426,488539,827537,840441,834652,777076,115422,37930,91353,554602,423670,541382,140716,592936,207156,251355,577940,324806,284016,146333,332942,341870,947412,748079,394129,696477,938837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 910163 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 910163 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]