SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009518 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009518 [ RunTime:0.001884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181210,17604,675777,1040826,978723,942509,334067,745297,1025114,711936,456908,343525,926758,279322,998229,35946,72824,469922,506580,498064,431971,1016662,501506,754449,466743,577103,622832,576583,830948,686714,567735,31007,748201,443248,458854,965613,520325,381276,972177,250400,123575,741587,568231,16878,678649,890584,277478,102704,478259,480449,486515,274919,788438,869341,757371,133170,960009,8405,180429,784129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]