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` = 491809 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491809 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423269,339076,198589,575441,811184,781892,594426,556010,412202,8502,591670,1027026,617945,19680,40972,706397,510456,997891,361809,216603,116383,14151,578771,659245,125354,209959,240473,558737,511287,920055,1040193,935598,827786,456472,281136,142388,502432,131783,429540,311671,559333,523304,4,312706,627586,1028466,77683,267210,953252,305145,203022,803204,372152,608918,942327,152597,519808,101817,756800,82291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]