SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354115 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354115 [ RunTime:0.003591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873249,849683,204022,154216,395993,170066,50573,740338,250236,820857,1006587,419820,111851,555328,82883,880293,90740,859568,406769,249352,967519,76256,607706,915569,905108,266320,288119,165886,333079,887370,992937,926989,443231,882900,328235,1011089,751602,217369,257622,973971,964758,248890,288384,940185,489350,859671,721778,647088,110915,738896,305178,413532,756087,124877,986370,214803,482767,439421,38352,282958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354115 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354115 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001588s ]