SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 865681 LIMIT 1 [ RunTime:0.001003s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 865681 [ RunTime:0.002021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793180,131139,406408,438923,792194,987029,1040019,188224,824721,162867,45618,225374,156529,466875,433680,804101,544524,190574,323884,674284,846471,926816,67133,78318,241054,134480,945596,85006,86188,379133,853842,597243,355446,83447,178500,591636,716569,623583,129152,839069,654858,936439,432702,965954,852893,48540,633919,143622,355381,280870,568331,130815,290411,1004900,845880,787898,831519,24862,54302,64223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014758s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 865681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 865681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003149s ]