SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044105 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044105 [ RunTime:0.003825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (8336,69878,987828,1013124,771979,866596,725642,171536,351379,196932,125412,222185,311174,903013,265139,455736,650010,662453,237272,594752,262684,301223,51625,589230,1030535,172749,1405,204920,435336,515292,709937,1039719,58362,527052,116992,606082,999119,625607,691452,119763,980303,462444,722534,601491,946768,865867,140908,696732,221863,125981,1045998,937402,871892,553567,610542,1020281,894599,178713,1030180,728962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]