SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009860 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009860 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553645,539664,289841,449416,783458,289408,562285,903543,193337,114395,943678,374208,400594,622879,426681,394359,586319,265897,885994,497759,733749,297273,200211,836479,826604,58680,482337,596130,845174,566601,486310,859674,406132,625746,276344,994610,2266,464832,661936,370995,82656,585188,971414,367048,475723,493784,139476,418722,595490,812190,365231,133424,740694,994946,683824,256058,384528,31156,110682,640891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]