SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285243 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285243 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291073,234128,110750,753138,911112,394056,817231,202217,136848,214700,779992,743609,54700,798793,539931,353262,131686,996262,1028303,225139,347433,816180,919089,230061,782564,343498,807456,231580,812314,409675,951004,631213,11805,1037821,291229,1025463,631206,1027829,867875,308678,854062,36220,25675,17094,48493,391340,176926,928746,804781,775561,887840,411415,452080,751130,391209,121403,330858,841772,984092,283298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]