SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580821 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580821 [ RunTime:0.007170s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (857612,375741,324208,211496,705887,880502,105073,525791,331221,1044065,42836,804416,985660,280900,14730,475530,888512,983436,52347,325002,563367,955183,140098,586149,958486,79004,369459,547903,162337,1034003,287266,655416,97967,74825,694858,866062,129325,161155,203613,289154,902220,295245,471286,808646,711946,18966,507930,923269,105908,860682,512726,167061,605817,807881,615472,982155,281227,127475,183007,502388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001137s ]