SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001507s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103791 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103791 [ RunTime:0.001496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (989450,545376,1027174,23682,928154,670896,640599,319429,9022,746233,318053,681004,112327,827039,149389,1006537,641549,719250,67364,564613,9216,613427,420391,780860,219055,706801,162557,624460,612901,163664,264205,512394,259830,398079,180052,831771,856165,255171,768781,191661,475735,578032,45594,895877,297406,753226,547008,1019429,480321,357706,3830,609578,209732,3714,449698,489366,908667,962850,356468,354230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]